I'm having a bit of trouble figuring out a formula to split the contents of cells that don't follow a uniform delimiter format. I have attached an excel spreadsheet with the data i'm trying to separate for reference. I need to split the "DocketNo" into three separate cells. in the column "DocketNo" The first set of numbers is the Docket number, the second set of numbers is the Sale number and the third set is the temperature.
the delimiters range from spaces, commas, full stops and forward slash
Can anyone help me with a formula that will help me split this data with minimal manual data manipulation!?
Thank you to anyone who can help.