I have a txt file of numbers like this:

100009,5047.103523,979.802248,497.537994,TRE,
100010,5042.865536,980.986387,497.561980,TRE,
100011,5019.806592,981.348742,497.390278,TG1,

I need to break it down into

100009 5047.103523 979.802248 497.537994 TRE

And want to put each number into a separate box on a spreadsheet.

I have 5,500 lines of code like this - any way to automate the process?

Thanks for any help on this!
Dave,