Find and replace TM symbol

[Grilleman]

Hello -

I would like a sub that finds and removes the "TM" symbol wherever it appears in each row containing a text description. See attached worksheet.

Thanks

Grilleman

[AlKey]

You can easily remove it by going to Find tool (Ctrl+F), copy and paste "TM" symbol, and click Replace, Replace All.

[Grilleman]

Tries that - it does not work.

[AlKey]

Tries that - it does not work.

It works great. Just click on the entire column and than follow post #2

[Kenneth Hobson]

This is built-in so AlKey's solution should be standard fare.

If you are using the same font, a simple recorded macro should suffice.

e.g.

Please Login or Register  to view this content.

[Grilleman]

All -

I see what I was doing wrong. I was trying to replace the TM not the symbol ™. Both solutions mentioned above work great. Thanks for the help!!