Excel Extracting Phone Numbers From A Cell

Published: 07 September 2017
on channel: Alan Jarvis

21,197

129

   • Excel Extracting Phone Numbers From A...   - Excel Extracting Phone Numbers From A Cell

Another SQA Lecture!

Jonathan has a very large data set, and the data is a mess! It looks like there are lots of different columns that have all been squished into one, but not in any discernible order! Normally, you could find some delimiter, like a comma, in which case you could just use text to columns...but not here!

Somewhere in there is a phone number...and that is the challenge...read the entire cell, and extract the phone number from it...wherever it may be.

Sounds difficult, but it's actually quite simple. All the numbers in his data set are UK mobile phone numbers. UK mobile numbers begin with "07", they're always 11 digits long, and that gives us something we can work with...

We will use the FIND function to locate the "07" within the string...that gives us the start point. Then we will wrap a MID function around it, and extract 11 characters from the point...simple!

This is a sample lecture from my course, Microsoft Excel Essentials: Level 2 - Intermediate/Advanced.

Get this course now!

Level 1: Microsoft Excel Essentials: Level 1 Basics - Excel Made Easy
The complete 4 hour course is yours for a low cost monthly subscription (first 2 months free!):
https://www.alangjarvis.com/excel-ess...

Level 2: Microsoft Excel Essentials: Level 2 - Intermediate/Advanced
The complete 9 hour course is yours for a low cost monthly subscription (first 2 months free!):
https://www.alangjarvis.com/excel-ess...

Level 3: Microsoft Excel Essentials: Level 3 - VBA Programming + Macros
The complete 13.5 hour course is yours for a low cost monthly subscription (first 2 months free!): https://www.alangjarvis.com/excel-ess...

Alternatively, you can purchase the complete set in...
Excel Essentials: The Complete Excel Series - Level 1, 2 & 3

The WHOLE 27.5 Hour Excel Mastery Series In One! From Excel Novice To VBA Programmer...
Available to buy with lifetime access for just $16.99 (normally $200) here:
https://www.alangjarvis.com/excel-ess...

This course is for suitable Excel 2007, Excel 2010, Excel 2013, 2016, 2019 & 365

Videos in the Level 1 series:
   • Opening Excel, And Creating A Desktop...
   • The Anatomy Of An Excel Workbook
   • What's Where In Excel In 5 Minutes
   • Always Do This First In Excel...Save ...
   • Entering Data In Excel
   • Editing Data In Excel
   • What To Do If You Make A Mistake In E...
   • Reverse Engineering A Sample Spreadsh...
   • Casing And Text Functions In Excel

Videos in the Level 2 series:
   • Excel: Proof Of Concept (excel view 2...
   • Excel: Planning Ahead
   • Creating A Data Entry Screen In Excel
   • Custom Formatting Dates And Times In ...
   • Simple Calculations With Time In Excel
   • More (Useful) Calculations With Time ...
   • It's About Time (And Dates) In Excel
   • Excel Calls Text Data - Or How To Ret...
   • Excel Calls Text Data 2 - This Time U...
   • Excel Extracting Phone Numbers From A...
   • Excel What Is The CHOOSE  Function Re...
   • Excel Dynamic Charting From A Drop Down
   • Excel Extracting a Unique List, And S...
   • Excel SUMIF With Dynamic Sum Range
   • Excel VLOOKUPs With Pictures!

Videos in the Level 3 series:
   • Excel VBA Why Should I Learn How To Code
   • Excel VBA The 15 Golden Rules Of Coding
   • Excel VBA Introducing The Visual Basi...
   • Excel VBA Saving Macro-enabled Workbo...
   • Excel VBA Moving VBA Code Around
   • Excel VBA Stepping Out. Well, In Actu...
   • Excel VBA Introduction To The Coding ...
   • Excel VBA Introduction To Programmers...
   • Excel VBA Introduction To Automating ...
   • Excel VBA Introduction To Web Query S...
   • Excel VBA Introduction To The VBA Wor...
   • Excel VBA Introduction To The VBA Win...
   • Excel VBA Introduction To Automating ...
   • Excel VBA Introduction To Automating ...
   • Excel VBA Introduction To Automating ...
   • Excel VBA Calling A Sub Stored In A D...
   • Excel VBA Introduction To The Mass Da...
   • Excel VBA Get Rid Of Rows In An Array...
   • Excel VBA Emailing Routine Adding a S...
   • Excel VBA Adding A Date Stamp, And Go...
   • Excel VBA Saving An Individual Sheet ...
   • Excel VBA Saving Multiple Sheets To A...
   • Excel VBA Animated Charts...With A Li...
   • Excel VBA Extracting Specific Data Fr...
   • Excel VBA Finding A Search String in ...

Watch video Excel Extracting Phone Numbers From A Cell online without registration, duration hours minute second in high quality. This video was added by user Alan Jarvis 07 September 2017, don't forget to share it with your friends and acquaintances, it has been viewed on our site 21,197 once and liked it 129 people.

2,804