Need to remove hypens from typed in telephones (not formatted)!!

trixiebme · Jun 30, 2005

Rows of typed in phone numbers with hyphens...not formatted cells...how do I
remove the hyphens ONLY?!?!

Please I need an answer FAST!

Guest · Jun 30, 2005

Hi

Try using Find/Replace (Ctrl H). That should do the job for you.

Andy.

bj · Jun 30, 2005

or you could use = replace(A1,"-","")