I'm sure there's a real formula, but I use the find & replace feature. Put
the character to remove (one at a time) in the Find box, leave the replace
box empty, and replace all. You have to select the column you want to
remove them from.


"Russ" wrote in message
...
how do I remove data from cells ex. (232)-555-1212 to 2325551212