Converting .rtf file into excel

  • 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
 
Give this a try,
Go to Data drop down menu
Select Import External Data
Select Import Data option
At Import Data window be sure to select "All Files" in
Files of type field at bottom of window
Go to drive/folder file is stored in -
Follow Wizard steps for formatting
Good Luck
 
Back
Top