Changing Phone number format

[Noncentz303]

I have a sheet that I would like to convert data over to. But all the phone
numbers on the sheet have this format

###+###-#### and I would like to convert it to
###-###-#### so basically I just need the + replaced with a - when the
record is entered into the table.

I know this is easy but im not familiar with at excel functions
Thanx

 

[LT]

I have a sheet that I would like to convert data over to. But all the phone
numbers on the sheet have this format

###+###-#### and I would like to convert it to
###-###-#### so basically I just need the + replaced with a - when the
record is entered into the table.

I know this is easy but im not familiar with at excel functions
Thanx

Hi.

I believe what you want is below using the Replace function. The firs
part (A1) is the cell with old number with the + in it.

The "4" is to move over 4 characters to the right (416+) It will stop
at the +.

The "1" is to replace only ONE char to the right, where you choose to
start in the text string. (the 4 over)

And the "-" is what you want to replace the + with.

416+896-8229 =REPLACE(A1,4,1,"-")

Hope that helps!

-LT

 

[CLR]

Highlight the column of phone numbers to be changed, then do Edit > Replace >
and then follow the menus........


Vaya con Dios,
Chuck, CABGx3