Replace Symbol "Code(63)"
 

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.

Hi!

Goto EditFind

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

Biff

-----Original Message-----
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,

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" wrote:

Hi!

Goto EditFind

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

Biff

-----Original Message-----
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.


.

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

-----Original Message-----
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" wrote:

Hi!

Goto EditFind

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

Biff

-----Original Message-----
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.


.


.

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.

"Biff" wrote:

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

-----Original Message-----
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" wrote:

Hi!

Goto EditFind

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

Biff

-----Original Message-----
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.


.


.