Remove unwanted characters

[ml0824]

I have a list of phone #'s in the format

519-555-5551
410-555-5222

I would like to remove the dash so the output looks like

5195555551
4105555222

I've tried find and replace but it does not work. Any thoughts?

TIA

 

[Peter_SSs]

Re: Help-Remove unwanted characters

I've tried find and replace but it does not work. Any thoughts?

If Find/Replace does not work to remove the dashes then most likely those dashes are part of a custom cell formatting. Have a look at the cell formatting and you may just need to change the cell formatting to General.

Do you have any numbers that would have leading 0s?

 

[jasonb75]

Re: Help-Remove unwanted characters

If find and replace doesn't work then it might be a custom format applied to the numbers, in which case you just need to format the cells as general.