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