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:
Gets TRIM'd down to:Please Login or Register to view this content.
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.Please Login or Register to view this content.
Basically I want to take the TRIM version and convert to columns automatically
....etcPlease Login or Register to view this content.
Bookmarks