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

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

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

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