Delimit string to columns after using TRIM?

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:

Please Login or Register  to view this content.

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.

Basically I want to take the TRIM version and convert to columns automatically

Please Login or Register  to view this content.

....etc

Data..Text to Columns is one option

You could write your own macro, using the macro recorder. If you have not used it before, practice a few times using T2C, the click the macro record button - next to READY at the botton left corner

do what you want, it will be recorded into a macro. click again when you are finished. Then create a "shape" and allocate the macro to that, you will then have a macro button

I recored this in about 15 seconds, and you dont even need to remove spaces, T2C does it all for you

Please Login or Register  to view this content.