RTF to EXCEL

user9000

New Member
Joined
Sep 13, 2002
Messages
11
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.
 

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.
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.
 
Upvote 0
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!
 
Upvote 0
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.......!

:)

??
 
Upvote 0
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?
 
Upvote 0
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.


:(
 
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
1,218,514
Messages
6,142,910
Members
450,453
Latest member
spaudel

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top