converting .rtf to excel 2002

  • Thread starter Thread starter DK
  • Start date Start date
D

DK

Thank you in advance for your help.

I have an address label file in .rtf format. It has 3 X
10 labels on one page totally about 14,000 address
labels. I wanted to convert it into MS Excel 2002 so i
can get under one column the first name, the second
column the last name, the thrid column the street address
and so on. How do I do this in excel 2002?

I tried using the Edit, Past Special, Paste as Text
function but the data is not user friendly. By using this
approach, I will have to use brute force in cutting and
pasting names and addresses in the respective columns
described above. Not good when you have 14,000 address,
right?

Any suggesitons would be highly helpful.

Regards,

DK
 
Hello,
I hope this is helpful.
Goto Data drop down menu
Select, Import External Data
Select, Import Data
Select, location of file
Follow delimiter directions.
You will be prompted for column break downs etc..
Good luck
 
Thx for your response. The only problem with your
solution is that it brings everything in one column and I
have to use brute force again to copy and past first name
and last name and addres1 and address2 and state and city
and zip in separate columns for each person. doing this
for 14,000 entries will be a nightmare.


any other suggestions would be highly appreciated.
 
Back
Top