Excel VBA Tips n Tricks 47 Custom Function Phone Number Function to Add Spaces, Hyphens and Parent

3,836 views · Published 4 July 2013 · 13:32 · Indexed 23 September 2026

Channel: ExcelVbaIsFun · 2013 · Education

Watch on YouTube

📊 Free Workbooks: https://www.excelvbaisfun.com/links?utm_source=youtube&utm_medium=desc&utm_content=uwApISU7eOY
🥷Join Excel Ninja Pro: https://www.excelvbaisfun.com/ninjapro🔥(2 Months FREE On Annual Plan Auto Applied)
🥷Excel Ninjas FB Group: https://www.excelvbaisfun.com/xlninjas (Free downloads, Trainings, Live Q&A and more)

With this function, you can automatically format Phone numbers. 
From 5556677 to 555-6677
From 918.4996789 to (918) 499-6789 etc. Check it out!

Fantastic Developer Tools:
🔒 Transform Any Excel File Into A Locked EXE: https://www.excelvbaisfun.com/secure-excel-files (25% off with code ‘25OFF’)
🟡 Create Custom Installers: https://www.excelvbaisfun.com/custom-installers 
👋 Business Inquiries, Consulting, Comments, etc: https://www.excelvbaisfun.com/contact/

More from this channel

• 3:17 Excel VBA Tips n Tricks 37 Using SELECT CASE instead of IF THEN Pt 4 CASE IS Using Operators

  ExcelVbaIsFun

  2,919 views · 16 June 2013

• 16:45 How to Make Comboboxes Disappear, Use MultiColumn Listbox and Track Records on Userform Q n A

  ExcelVbaIsFun

  3,543 views · 28 August 2013

• 1:44 Click Here For Links to the Challenge VIDEOS!!!

  ExcelVbaIsFun

  675 views · 10 December 2013

• 6:50 Competition 1 - Inventory - Chris H

  ExcelVbaIsFun

  2,435 views · 11 December 2013

• 1:48 Competition 1 - Inventory - Hamilton R

  ExcelVbaIsFun

  1,118 views · 11 December 2013

• 4:36 Competition 1 - Inventory - Kevin N

  ExcelVbaIsFun

  4,912 views · 11 December 2013

• 3:09 Competition 1 - Inventory - James T

  ExcelVbaIsFun

  1,454 views · 11 December 2013

• 3:50 How to Cancel Print Job (if it's not legal paper) in Excel VBA

  ExcelVbaIsFun

  3,281 views · 25 December 2013