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


"trixiebme" wrote:

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

Please I need an answer FAST!