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

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

Please I need an answer FAST!

Hi

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

Andy.

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

Please I need an answer FAST!

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!