Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Text to columns
The answers you got Friday didn't help????????
Debrap29 wrote: I am having a problem with "Text to Columns". I have a column which includes information which is separated by "/". However, the "/" is not included in every row of the column. i.e. 1 row in the column contains "ADMIN1/232322" and that's easy to make into two columns, however in row 2 I have "Whatever". This information goes into the left column where "ADMIN1" would be, but I need it to go into the right column where "232322" would be. Is there a way of me getting this information into the correct column? -- Debrap29 ------------------------------------------------------------------------ Debrap29's Profile: http://www.excelforum.com/member.php...o&userid=36127 View this thread: http://www.excelforum.com/showthread...hreadid=559982 -- Dave Peterson |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combining Text from 2 Columns into 1 then Deleting the 2 Columns | Excel Worksheet Functions | |||
help with sorting text in columns to match other columns | Excel Discussion (Misc queries) | |||
merge text from 2 columns into 1 then delete the old 2 columns | Excel Worksheet Functions | |||
Linking text columns with text and data columns | Excel Worksheet Functions | |||
extracting text from within a cell - 'text to rows@ equivalent of 'text to columns' | Excel Programming |