If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
how to find and replace a symbol in my worksheet
I need help with finding and then replacing a symbol in my worksheet. In the
find and replace box there is no way to insert a symbol there. I have tried to cut and paste as well as to insert the symbol in the find box. If anyone has an idea on how to replace a bullet with a comma please let me know. Thanks TC |
#2
|
|||
|
|||
TC
In the Replace What: box you would hold down the ALT key then hit the ascii code number on the NumPad. Bullets are usually ALT + 0149 So.........select the cells. EditReplace what: ALT + 0149 you will not see anything in the what: box, but it is there. with: , Replace All. If the bullets are not ALT + 0149, download Chip Pearson's CELLVIEW add-in. http://www.cpearson.com/excel/CellView.htm With it you can determine what codes are in a cell. Gord Dibben Excel MVP On Tue, 3 May 2005 08:42:04 -0700, "TC" wrote: I need help with finding and then replacing a symbol in my worksheet. In the find and replace box there is no way to insert a symbol there. I have tried to cut and paste as well as to insert the symbol in the find box. If anyone has an idea on how to replace a bullet with a comma please let me know. Thanks TC |
#3
|
|||
|
|||
If you can't enter the symbol directly, you should still be able to enter its
numeric code, which you can do from the numeric keypad. I think the code for a bullet is 0149. Make sure the Nmm Lock key is on. Go to the find/replace dialog box. In the 'find what' box, press the Alt key and type 0149. Then in the replace with box, enter the comma. Then click replace. Sanford "TC" wrote: I need help with finding and then replacing a symbol in my worksheet. In the find and replace box there is no way to insert a symbol there. I have tried to cut and paste as well as to insert the symbol in the find box. If anyone has an idea on how to replace a bullet with a comma please let me know. Thanks TC |
#4
|
|||
|
|||
Sandford and Gord thank you both for the help it worked great. I was able to
find the code using =code() but I could not figure out how to enter the value. thanks TC "Sanford Lefkowitz" wrote: If you can't enter the symbol directly, you should still be able to enter its numeric code, which you can do from the numeric keypad. I think the code for a bullet is 0149. Make sure the Nmm Lock key is on. Go to the find/replace dialog box. In the 'find what' box, press the Alt key and type 0149. Then in the replace with box, enter the comma. Then click replace. Sanford "TC" wrote: I need help with finding and then replacing a symbol in my worksheet. In the find and replace box there is no way to insert a symbol there. I have tried to cut and paste as well as to insert the symbol in the find box. If anyone has an idea on how to replace a bullet with a comma please let me know. Thanks TC |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Find and Replace anomaly | BruceM | General Discussion | 7 | January 18th, 2005 05:47 PM |
how to find replace text or symbol with carriage return | jo | New Users | 10 | January 17th, 2005 06:21 PM |
Find and Replace with Wildcards | Luke Muehlhauser | General Discussion | 2 | August 8th, 2004 02:55 AM |
Find and Replace in Word 97 | Doug Robbins - Word MVP | General Discussion | 1 | May 28th, 2004 02:41 PM |
find all / replace all used in a selected range | oldguy | Worksheet Functions | 0 | February 26th, 2004 01:05 PM |