Replace Symbol "Code(63)"

[Guest]

I have transferred Supplier Contacts from Outlook to Xls format.
But in Address Column, there are a lot of that symbol that i wish to delete.
How to use the "Find and Replace" to achieve this deletion.

Thank you.

 

[Biff]

Hi!

Goto Edit>Find

Find What: ~?
Replace With: nothing, leave this blank
Click Replace All

Biff

 

[Guest]

Biff,

i am not sure the symbol code is 63 (like a SQUARE).

Still cannot to use ~? (do i have to replace "?").

Please re-advice.

Andri

 

[Biff]

Hi!

Ok, When you said code(63) I thought that maybe you saw
the "?" and did a =CODE(). The char code for a "?" is 63.

Maybe this will help:

http://www.mvps.org/dmcritchie/excel/join.htm#trimall

Biff

 

[Guest]

Dear Biff,
Thank you for the link, and i am sure i will be able to figure out the
problem after reviewing that link for some time.
Andri.