Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
organizing data imported via xml
I have data that is all being put into one cell and I am trying to find a way
to "extract" pieces of the info into separate cells, much like the "text to columns" function, but I need "text to rows" the data is organized like this: Weight: 25 lbs Dim: 12 X 12 X 12 Color Red All that info is in one cell, spaced exactly how you see it above. I would like it to be split into separate cells like this Wieght 25lbs -- Dim: 12 X 12 X 12 -- Color Red Hope this makes sense to someone that has a solution |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
organizing data imported via xml
Why would you need Text to Rows if you want the contents split into 3 cells in 3
columns per your example? Text to Columns will do that Try =TRIM(A1) to see if the extra spaces will clear then muck about with Text to Columns Or maybe turn off wrap text if enabled. You might have control characters like Alt + 0010 you could use to split out to 3 cells. Gord Dibben MS Excel MVP On Thu, 31 Jan 2008 15:49:02 -0800, Roger wrote: I have data that is all being put into one cell and I am trying to find a way to "extract" pieces of the info into separate cells, much like the "text to columns" function, but I need "text to rows" the data is organized like this: Weight: 25 lbs Dim: 12 X 12 X 12 Color Red All that info is in one cell, spaced exactly how you see it above. I would like it to be split into separate cells like this Wieght 25lbs -- Dim: 12 X 12 X 12 -- Color Red Hope this makes sense to someone that has a solution |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help me parsing Data and Organizing | Excel Worksheet Functions | |||
Help organizing data using Pivot Table | Excel Discussion (Misc queries) | |||
totaling and organizing data | Excel Discussion (Misc queries) | |||
Help with organizing data | Excel Discussion (Misc queries) | |||
Organizing Data | Excel Worksheet Functions |