How to Remove Square Character?

[InfrequentVisitor]

Hello,

The special character I'm referencing won't appear in my post when I paste the Excel data as HTML. It essentially looks like a larger version of the square special character in the symbol library. When I click on the cell, the formula bar displays the square with a question mark in it.

This square character is in an Oracle extract and I have to manually scroll through the data to delete it. I can't paste it into the Replace function, because it pastes as nothing; however, the square still impacts data if I don't delete it.

Respectfully,

Eric

 

[Joe4]

Can you tell us which ASCII character it is?
You can find out like this. Let's say it is appearing as the first character in cell A11.
Then use a formula like this to return the ASCII number of the character:

=CODE(LEFT(A11,1))

 

[Fluff]

If the answer to what Joe4 has suggested is 63 replace CODE with UNICODE
=UNICODE(LEFT(A11,1))

 

[NdNoviceHlp]

It's called a pilcrow (chr ascii 13 I think). The Clean function will remove it. Dave

 

[InfrequentVisitor]

All,

I learned much more than I thought I would.

It's code 12. The Clean function worked quite well. The Unicode function doesn't appear to exist in 2010 Excel, but I can always use it at home w/ my 2013/16.

Thank you,

Eric