Removing UNICHAR from Excel

[Cheryl55]

Hello,

I have a couple of columns that seem to have UNCHAR (62) in them. The ? symbol. I am trying to remove them. I tried to find and replace but it removed the entire cell.

Here is an example of what I am trying to fix:
Arrow Rivet, ?.312 Hole, ?.219 Panel Thk

 

[Cheryl55]

I should say that in the original Excel document the character was hidden. It only showed up when I converted it to a CSV document.
This is how it looks in the XLS document
Arrow Rivet, .312 Hole, .219 Panel Thk

 

[jtakw]

Hi,

Try, when you do your Find and Replace...

Find what, add the Tilde character in front of ?, ~?

Replace with, leave blank

 

[Cheryl55]

Yes!!! Thanks!!!!

 

[jtakw]

You're welcome.