Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

RTF fields in external data

Status
Not open for further replies.
LFB

LFB

Programmer
Jul 2, 2001
38
0
0
AU
OFFICE 2000.
I have created a query to an external data source (SQL SERVER 2000 SP 2). The source contains a NOTES field that contains RTF text and code.

As soon as I bring the query into Excel the RTF formatting is pasted into the cell which makes it very difficult to read. I have tried to CAST and CONVERT the data at the source but it makes no difference.

Does anyone know of a way to format these cells to remove all the RTF code?

Thanks
 
Status
Not open for further replies.

Similar threads

grnzbra
  • Locked
  • Question
Force Data Entry Format in Excel
Replies
10
Views
145
combo
combo
GPnew
  • Question
Power Pivot Filter out Rows where data is not in all columns
Replies
14
Views
264
combo
combo
kwbMitel
  • Locked
  • Question
Lost edited data in Excel File
Replies
3
Views
85
Scott24x7
Scott24x7
Cpreston
  • Locked
  • Question
Trim Multiple items in one column
Replies
2
Views
111
Andrzejek
Andrzejek
ladyck3
  • Locked
  • Question
Excel 365 - Working with Tables - Calculating data from one worksheet to another. 2
2
Replies
30
Views
214
combo
combo

Part and Inventory Search

Sponsor

Back
Top