RTF Data Conversion

[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

[ScottO]

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

"westport" <ray.collins@halliburton.com> wrote in message
news:1121195788.890443.169250@g14g2000cwa.googlegroups.com...
| 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
|

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

[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

"westport" <ray.collins@halliburton.com> wrote in message
news:1121263021.654892.34980@g49g2000cwa.googlegroups.com...
| 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.
|

[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.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"westport" <ray.collins@halliburton.com> wrote in message news:1121195788.890443.169250@g14g2000cwa.googlegroups.com...
> 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
>