mickferrari
asked on
Split Excel Cell with no uniform delimiter
Hello Experts!
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.
Split.xlsx
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.
Split.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Perfect. That worked exactly how i wanted.
Thank you.
Thank you.
http://www.eileenslounge.com/viewtopic.php?f=27&t=5709
http://www.atlaspm.com/toms-tutorials-for-excel/toms-tutorials-for-excel-finding-the-position-of-the-first-integer-in-an-alphanumeric-string/
Then you will want to use FIND, LEFT, RIGHT and MID.