Clean & Reformat mobile number into excel

shantanu97

New Member
Joined
Aug 27, 2020
Messages
6
Office Version
  1. 365
  2. 2019
Platform
  1. Windows
I have three columns with home, business & mobile phone. I wanted to format these numbers so I can filter by country code. Any help provided in cleaning these mobile number. File Attached by name "Test" in google drive:Test.xlsx
any help appreciated.
 

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().
like this?
Mobile PhoneHomePhoneBusiness Phone
981107098291728901044701142263485
9810883162981031952209883273984
8618062896948991180013309918751218
91844598898691904510998609560447000
966507477799968 9919 442703325656329
98103714579199990021239811855844
852705058496505398429211982437
91842340073193113914727290927215
0999920044199902456701166211801
919319145871999963373201166538816
955521322391776684454209479394779
974665557141(360)639695901122465366
91851081080198110121929717395275
919990034151981040804902261985526
919958644642852621181739833117371

but what with, eg. 1 (314) 3788346 ?
any criteria or representative example of expected result?
 
Upvote 0

Forum statistics

Threads
1,213,546
Messages
6,114,256
Members
448,557
Latest member
richa mishra

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top