RTF Data Conversion

  • Thread starter Thread starter westport
  • Start date Start date
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
 
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
|
 
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.
 
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.
|
 
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.
 
Back
Top