remove bullet points from cells

[dbwiz]

Col C has apparently been copied from a large Word doc into Excel - and each cell is not only wrap around text, but has bullet points. Other than going into each cell and clicking delete a few times, is there a way to remove all the bullet points - or replace them with blank?

 

[Ritt]

Col C has apparently been copied from a large Word doc into Excel - and each cell is not only wrap around text, but has bullet points. Other than going into each cell and clicking delete a few times, is there a way to remove all the bullet points - or replace them with blank?

Did you try Find and Replace. The Find would be the bullet and spaces if any and the replace would be nothing not even a space. Works in 2007
Maybe it will work for you.

 

[tweedle]

Possible formula solution:

So if E5 is the junk cell;
=CLEAN(SUBSTITUTE(E5,"•",""))

May copy/paste your bullet into the formula.

SUBSTITUTE performs the bullet exchange, CLEAN strips off non-printable characters.