Dave Lightbody Wrote:
-------------------------------------------------------
> 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!
Hello Dave,
I managed to create this by opening the TXT file in Word, converting the text into a 'table' selecting 'comma' for the separator, and copying/pasting the result into Excel
100009 5047.103523 979.802248 497.537994 TRE
100010 5042.865536 980.986387 497.56198 TRE
100011 5019.806592 981.348742 497.390278 TG1
Hope this is of some help.
I'll post step-by-step moves if you're not too sure what I'm suggesting.
MJ
Edited 1 time(s). Last edit at 07/16/2009 07:52PM by MJ Thomas 2.