RTF to EXCEL

[user9000]

Does anyone know how to convert a Microsoft Word .RTF file into a Microsoft Excel file? I have tried everything I know and I have no success other than getting everything crammed into column A in excel. Thank you.

 

[stevebausch]

In Excel 97 and Excel 2002:


Ctrl-A
Copy
Paste

Each line will be a row of text, occupying one cell.

Twenty lines, twenty cells, in one column.

 

[user9000]

No this does not work. The RTF document I am using was an export from Seagate Crystal Reporting. It is over 135 pages long. It cannot be pasted into Excel.

Do you know of any converter program?
Thanks!

 

[XL-Dennis]

user9000,

Welcome to the board

Have You tried to open it in MS Word and save it as *.doc and then open it in XL?

Here´s an URL to some tools that may help You (I have no experience of them)

http://www.softinterface.com/WCE/WCE.HTM

Kind regards,
Dennis

 

[user9000]

Yes. I saved it as a .doc then tried to open in Excel, but it says "invalid format".
I also tried the software link you mentioned, and had no success either.

Surely SOMEONE out there has has to convert .RTF to Excel????

I'm BEGGING.......!



??

 

[stevebausch]

Have you tried Paste-Special?

 

[MarkHenri]

Since the document was generated by an automated process, can you use a different layout in CR and format it differently? Preferably, some sort of tab delimited text file format. Or maybe I can show you an easy way to extract it from the database without even using CR?

Can you send it to me so I can play with it?

 

[user9000]

Steve, Yea the paste/special did not work.

 

[user9000]

markhenri-

The report was generated by Seagate Crystal Reports then exported into the format I have which is a RTF file that opens in WORD. I don't have access to the database from which the report was generated. I am famailiar with Crystal because I use it at my business, but I am unable to import the RTF into Crystal, Excel, or anything.

The file is extremely large and the company that sent it to me sent it this way on purpose so that I would be unable to sort/manipulate the data for further analysis. I know it was generated from Crystal bc it says so when I do a properties on the file.

I cannot send the file as it is confidential information. So I guess I'm stuck.

I can't import to CR.
I can't import to Excel.

 

[dk]

Hi,

Why not just open the file in Word, select everything (Ctrl A) and copy it into Excel?

Does that work for you?

_________________<font face="Impact">Hope this helps,
Dan</font>
This message was edited by dk on 2002-09-15 10:34