Removing dashes in phone numbers

[Guest]

Can anyone tell me how to remove the dashes in a phone number. My data
current data is 1-800-555-1212 and I would like to remove the 1- and have the
number as 8005551212

Thanks in advance for your help
R

 

[pietlinden]

Can anyone tell me how to remove the dashes in a phone number. My data
current data is 1-800-555-1212 and I would like to remove the 1- and have the
number as 8005551212

Thanks in advance for your help
R

Replace(Right$([TelNo],Len([TelNo])-2),"-","")

 

[Guest]

That worked perfectly....Thank you very much.

R

Can anyone tell me how to remove the dashes in a phone number. My data
current data is 1-800-555-1212 and I would like to remove the 1- and have the
number as 8005551212

Thanks in advance for your help
R

Replace(Right$([TelNo],Len([TelNo])-2),"-","")