Clean & Reformat mobile number into excel

S

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

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.
Sort by date Sort by votes
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
You must log in or register to reply here.

Similar threads

B
  • Solved
Extracting a specific number of characters from a multiline cell
Replies
7
Views
350
etaf
etaf
R
  • Solved
Separate Phone Numbers
Replies
4
Views
127
myall_blues
myall_blues
C
  • Question Question
Only Brings Unique Value Across
Replies
3
Views
58
kvsrinivasamurthy
K
J
  • Question Question
Clean up List of Phone Numbers
2
Replies
11
Views
2K
alansidman
A
E
  • Question Question
Update Item Description Based On Accessories Ordered With It
Replies
1
Views
240
SanjayGMusafir
SanjayGMusafir

Forum statistics

Threads
1,223,904
Messages
6,175,295
Members
452,633
Latest member
DougMo

Share this page

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