RTF Data Conversion

W

westport

I have RTF data brought into Excel via MS Query. Now I need to convert
the data into legible text. Is there an add-in that will accomplish
this?

Many Thanks in advance!!

Ray Collins
 
S

ScottO

Have you tried using Text To Columns in the Data menu?
Rgds,
ScottO

| I have RTF data brought into Excel via MS Query. Now I need to convert
| the data into legible text. Is there an add-in that will accomplish
| this?
|
| Many Thanks in advance!!
|
| Ray Collins
|
 
W

westport

Scott,


Thanks for the reply. I don't think that will work for me - looking
for a way to automate the process and I don't see how that tool will
work.

Thanks again.
 
S

ScottO

Is your incoming data in a defined format, or does it jump all over the
place?
If the data is consistent, then Text To Columns can work for you.
S

| Scott,
|
|
| Thanks for the reply. I don't think that will work for me - looking
| for a way to automate the process and I don't see how that tool will
| work.
|
| Thanks again.
|
 
D

David McRitchie

Without a description of why the text is illegible (what you see) and
want you want it's difficult to provide any answer. If each cell has the
data where it belongs you might try TrimALL macro on a selection
within a copy of your worksheet to see if that helps.
http://www.mvps.org/dmcritchie/excel/join.htm#trimall
It will remove spaces from the front and back including Char(160)

By automate, presume you mean use a macro after you've already
pulled your data to the workbook. Was the query run from an Excel
macro.
 
Top