Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text to columns
Hello everyone,
can I make this function work over a number of rows, where the text is not the same in each row? or does it work on 1 column / 1 row at the time? Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text to columns
Vince
Will work on one column only, but multiple rows. If the data in the rows is quite unique you could wind up with a lot of putting things back together to get what you want. There are various types of separators/delimiters so try to find one the will do the job on "most" of the rows. Sometimes you have to make a few passes to get it all broken out. Keep the original column and work on a copy or copies of that column. Gord Dibben MS Excel MVP On 28 Sep 2006 14:42:42 -0700, "Vince" wrote: Hello everyone, can I make this function work over a number of rows, where the text is not the same in each row? or does it work on 1 column / 1 row at the time? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I unwrap text to columns? | Excel Discussion (Misc queries) | |||
Text to columns - one way street? | Excel Discussion (Misc queries) | |||
How do I convert from text to columns automatically on import? | Excel Discussion (Misc queries) | |||
comparing columns of text (cross-searching) | Excel Discussion (Misc queries) | |||
Text to columns | Excel Discussion (Misc queries) |