Okay, so I have a row of data with lots of spaces between characters, simple to use TRIM to remove all but 1 space between each 'column' in the cell. Can I use an array formula or macro to transfer each 'column' of data within that cell to an actual column?
Example:
92,481 4,466 4,436 18,454 20,113 896 17,399 102,362 10,318 9,810 1,316 538 28,788 38,674
Gets TRIM'd down to:
92,481 4,466 4,436 18,454 20,113 896 17,399 102,362 10,318 9,810 1,316 538 28,788 38,674
With spaces in between. I can't use LEFT/MID because if say, the first 'column' changes to 101,451 upon data refresh I will lose characters.
Basically I want to take the TRIM version and convert to columns automatically
Column1 Column2
92,481 4,466
....etc
Bookmarks