Convert a Word rtf file into excel

  • Thread starter Thread starter colorado808
  • Start date Start date
C

colorado808

Hi,

I am trying to get data out of an rtf file into excel, however it is putting
all information into 1 column,... Anyway to spread the data across multiple
columns just like it looks in the rtf file? Please let me know.

Thanks,
Joan
 
Open the rtf file in WordPad and save it as txt.

Open Excel and then from Excel:

Data > Open External Data... > Open Data
and the submit the filename

Tell the Import Wizard how to separate the fields.
 

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

Converting RTF file into TXT file 2
Convert Word To Excel 2
problem importing rtf files into excel 1
RTF data from Excel 2007 to Access 2007 1
Merging RTF files into one RTF file 6
Convert report to rtf format and e-mail it 1
Outlook 2003: convert all RTF emails to HTML 2
Converting doc & docx files to RTF. One file grew very big 3

Back
Top