How do I Remove bullets from text data in Excel cell with macro?
 

Bulleted lists are not part of Excel.

Are you working with something pasted from Word or from HTML
See http://www.mvps.org/dmcritchie/excel/join.htm#trimall
also read the topic above you will have to include the bullet character
in a substitution it is probably CHR(149) but you may have to check
with worksheet function CODE to fine out for sure.

If you mean the square bullets that are used to represent unprintable
characters. Turn on cell wrap under Format, cells, ...

It would be better to repeat the question in the body, but at least
you were clear that the question was in the subject rather than leaving
the body blank..
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Trav" wrote in message ...
Please help me with this question...

I need to run a macro that will automatically remove bullet formatting from
text data in Excel cells on a worksheet.

Thanks.