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:

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

Data..Text to Columns is one option

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

Sub Slit_to_columns()
'
' Slit_to_columns() Macro
'
    Selection.TextToColumns Destination:=Range("A1"), DataType:=xlDelimited, _
        TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=True, Tab:=True, _
        Semicolon:=False, Comma:=False, Space:=True, Other:=False, FieldInfo _
        :=Array(Array(1, 1), Array(2, 1), Array(3, 1), Array(4, 1), Array(5, 1), Array(6, 1), _
        Array(7, 1), Array(8, 1), Array(9, 1), Array(10, 1), Array(11, 1), Array(12, 1), Array(13, 1 _
        ), Array(14, 1)), TrailingMinusNumbers:=True
End Sub

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