Clean Mobile Numbers list using Len and Right functions in Excel
You have a list of 1000 mobile numbers, but all are not properly formatted as 10 digits. Some are less than 10 digits (incorrect numbers), some have a 0 or a 91 before the number, and some are just more than 10 digits (incorrect numbers).
Len and Right are 2 text functions in Excel which are extremely useful to clean up mobile numbers or any such kind of data.
For more videos to learn excel, click this link
• Learn Excel's Tricks
SUBSCRIBE!
/ @excelrush
Blog
Visit www.ExcelRush.com for the free blog to learn Excel in-depth.
Rushabh Shah is an expert in training Professionals & Students in Excel's Advanced features & formulas. These tutorials are simply a way to spread the knowledge and make people more productive using Excel.
For Classroom & Online Live Trainings with Rushabh, visit www.DLTC.co
