View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Pete
 
Posts: n/a
Default I'm stumped, splitting up a clump of text into useable information

Well, you might be better taking up Chuck's offer ...

I've looked at your text file in Notepad. With word-wrap on and a few
hard-returns, you can see the structure in there quite easily and some
codes are fairly obvious - " for ", < for Left Tab etc. You
could do successive Find & Replace within Notepad to tidy up the file
quite a bit. However, there are other codes - presumably c2, c3 etc
relate to column 2, column 3 - so it's really down to how well you can
recognise patterns as to how long it will take you.

I think the general strategy would be to use Notepad (or Wordpad) to
convert this into a format which could ultimately be read by Excel. You
may still have a lot of tidying up to do once the data has been put
into Excel.

Pete