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.
 

Some videos you may like

Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result

stevebausch

Well-known Member
Joined
May 11, 2002
Messages
810
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

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

user9000

New Member
Joined
Sep 13, 2002
Messages
11

ADVERTISEMENT

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.......!

:)

??
 

MarkHenri

Board Regular
Joined
Aug 2, 2002
Messages
106

ADVERTISEMENT

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

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

MrExcel MVP
Joined
Feb 15, 2002
Messages
2,940
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
 

Watch MrExcel Video

Forum statistics

Threads
1,118,009
Messages
5,569,596
Members
412,281
Latest member
GraYmOnD0808
Top