Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Text to Columns Question
I have 6 fields of data all in column A but each row the data is spaced out
differently, not even close. The fields themselves do not have any spaces but obviously there various spacing beteen the fields. The first feild is flush left but all the others are all over the map. Is there a way I can prepare the data so it's sumwhat lined lined up enough to get a accurate Text to Columns without hacking off some text in some rows? It's 17k+ rows. TIA Dennis ============== |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
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) | |||
Messy Text to Columns | Excel Discussion (Misc queries) | |||
Text to Columns - moves text up | Excel Discussion (Misc queries) | |||
text from one column into multiple columns | Excel Discussion (Misc queries) |