Convert a Word rtf file into excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

colorado808 - 29 Jan 2008 18:20 GMT

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

Reply to this Message

Gary''s Student - 01 Feb 2008 16:23 GMT

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.

Signature

Gary''s Student - gsnu200767

> Hi,
>
[quoted text clipped - 4 lines]
> Thanks,
> Joan

Reply to this Message