D
David McRitchie
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..
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..