Microsoft Excel | Clean Phone Numbers | Clean SSNs | Remove Dashes | Convert to Digits

excel Sep 01, 2022
 

In Excel, it can be tricky to format certain numbers like phone numbers and SSN or social security numbers. The method described in this video will help you to clean your numbers.

If you have inconsistent data entry for your phone numbers, social security numbers, ID numbers or anything like that, you might need to try the SUBSTITUTE function to "clean" the extra stuff out of your data. Then you can format it appropriately.

This is the function I used. =--SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A2,"(",""),")","")," ",""),"-","")

Good luck!

Microsoft Excel Playlist

Dawn Monroe Training
Microsoft Office Specialist Master
239 S Pattie, Suite #2
Wichita, KS 67211

 PLEASE SUBSCRIBE for more tips!

🔔 Subscribe for Updates 🔔
YouTube
News Opt-In

❤️ Connect on Social ❤️
LinkedIn
Facebook
Instagram

💥 View Learning Opportunities💥
Calendar
Membership
Website

This video was recorded with Loom. Try Loom with a 14-day free trial. 

NOTE: In full disclosure, some links in this description may be affiliate links. Purchasing via these affiliate links gives me a small commission, at no cost to you, so I can continue to make videos on this channel. Thank you!

#excel #microsoftexcel #excelformats #excelformatting

SUBSCRIBE

Dawn Monroe On YouTube

JOIN

Join our mailing list to receive event schedules, articles and news.
Don't worry, your information will not be shared.

We hate SPAM. We will never sell your information, for any reason.