Importing Text file....need to manipulate text and spread across multiple columns.

[scottya]

I receive a number of different data files in varying formats. In orde
to effectively review the information, however, I need to format it an
sort it in a way that makes the data useful. Here is an example o
what I have (this infromation has been scrubbed) :

<Seam> First Name Neelakan Ready
<Seam> Last Name Chin
<Seam> Address 31 Bloomfield Lane,Apt #215
<Seam> City Auburn
<Seam> State Michigan
<Seam> Post Code 48336
<Seam> Country USA

Here is what I want:

USERID First Name Last Name Address City
<Seam> Neelakan Ready Chin 31 Bloomfield Lane Auburn

and so on...


I have been messing around with formulas as well as the data wizard bu
it never seems to come out correctly. I'm using Excel 2002 and a boo
called Excel 2000 Formulas by John Wlkenbach. Still to no avail.

I would very much appreciate any assistance you can provide.

Regards,

scot

 

[David McRitchie]

Hy Scott,
take a look at
http://www.mvps.org/dmcritchie/excel/snakecol.htm#dbdata