Forum Discussion
Converting 10 digit phone number with dashes to 11 digits with no dashes
I have a large list of 1200 clients phone numbers in Excel and I need to convert them as follows. 602-457-0377 Current value. 16024570377 Desired new value needed with no formula in the valu...
Riny_van_Eekelen Brilliant! This is exactly what I needed. Thank you so much! I was spending hours Googling it and watching youtube videos and now I can do my whole worksheet within a minute!
Prestige_Realty Great. Glad I could help.