Remove unwanted characters

ml0824

New Member
Joined
Nov 26, 2005
Messages
23
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

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
42,312
Office Version
365
Platform
Windows
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?
 
Last edited:

jasonb75

Well-known Member
Joined
Dec 30, 2008
Messages
7,158
Office Version
2019
Platform
Windows
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.
 

Forum statistics

Threads
1,082,505
Messages
5,365,968
Members
400,864
Latest member
RobynP51

Some videos you may like

This Week's Hot Topics

Top