Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Okay I am doing something wrong here.
I have a little over 350 lines of information that look something like this: 001 - ROTOR WILL NOT TURN I need to split the 001 from ROTOR WILL NOT TURN and get rid of the hyphen altogther. The problem is not all 001's are the same length, for instance, it could be R05C22 TOTAL HUMAN-COMBUSTION. So, I can't do a fixed width because it cuts out some of the data and the other way seperates every hyphen. I want it to look like this: A B 1 001 ROTOR WILL NOT TURN 2 R05C22 TOTAL HUMAN-COMBUSTION |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I seperate a full name field out into three seperate columns? | Excel Worksheet Functions | |||
seperate first 2 lines of column in seperate columns in same row | Excel Discussion (Misc queries) | |||
How do I seperate data from a pivot into seperate worksheets? | Excel Discussion (Misc queries) | |||
how do i seperate data from one column into two seperate ones in . | Excel Discussion (Misc queries) | |||
Seperate First and Last Name into different cells | Excel Worksheet Functions |