how to find and replace a symbol in my worksheet

[Guest]

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

 

[Gord Dibben]

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.

Edit>Replace

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

 

[Guest]

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

 

[Guest]

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