| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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. |
|
#2
|
|||
|
|||
|
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. . |
|
#3
|
|||
|
|||
|
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. . |
|
#4
|
|||
|
|||
|
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. . . |
|
#5
|
|||
|
|||
|
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. . . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to find replace text or symbol with carriage return | New Users to Excel | |||
| Wild Cards in Find and Replace | Excel Discussion (Misc queries) | |||
| Replace using wildcards | Excel Discussion (Misc queries) | |||
| insert checkmark symbol | Excel Discussion (Misc queries) | |||
| VB Find and Replace | Excel Worksheet Functions | |||
Linear Mode
