convert to excel

  • Thread starter Thread starter Pammy
  • Start date Start date
P

Pammy

I have the following inform in a word doc, there are 120 pages of these
items. I want to convert to excel in columns with everything to the left of
/ as the header then the infor would populate in the correct col. I am going
blank trying different ways. Please help. using 2003 word...Thanks,

MKE/STOLEN xxx ORI/ab122222 SER/PZ12345 MAK/LUG CAL/9 TYP/PI DOT/20041208
OCA/00-111111 NOA/N ORI IS NASHVILLE METRO NASHVILLE 615 123-1123
NIC/G1234505 DTE/20041216 0646 EST
 
This forum is for Word?
There are eleven slashes '/' in the string of text you have posted?. It
should be possible to split the text into a Word table if you could identify
exactly what constitutes the header and what constitutes each 'record' - and
assuming that there are the same number of '/' slashes in the header and in
each record and that they are where you wish to break.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

convert to excel 1

Back
Top