+ Reply to Thread
Results 1 to 5 of 5

Multiple Phone Numbers in Same Cell

  1. #1
    Registered User
    Join Date
    03-03-2023
    Location
    United States
    MS-Off Ver
    365
    Posts
    3

    Multiple Phone Numbers in Same Cell

    Good day everyone. If you're reading this, I hope you're having a fair day.

    Question:
    Is it possible to ask Excel to format multiple numbers in the same cell and transform them into numbers.

    Example:
    Cell A1 has 3 phone numbers unformatted. 8881234567,8885678910,8883456789 > > > (888) 123-4567, (888) 567-8910, (888) 345-6789.

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,811

    Re: Multiple Phone Numbers in Same Cell

    Power Query Solution

    Please Login or Register  to view this content.
    Power Query is a free AddIn for Excel 2010 and 2013, and is built-in functionality from Excel 2016 onwards (where it is referred to as "Get & Transform Data").

    It is a powerful yet simple way of getting, changing and using data from a broad variety of sources, creating steps which may be easily repeated and refreshed. I strongly recommend learning how to use Power Query - it's among the most powerful functionalities of Excel.

    - Follow this link to learn how to install Power Query in Excel 2010 / 2013.

    - Follow this link for an introduction to Power Query functionality.

    - Follow this link for a video which demonstrates how to use Power Query code provided.

    Excel 2016 (Windows) 64 bit
    A
    B
    C
    D
    E
    1
    Column1 Proper Format1 Proper Format2 Proper Format3
    2
    881234567,8885678910,8883456789 (881) 234-567 (888) 567-8910 (888) 345-6789
    Sheet: Sheet1
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,396

    Re: Multiple Phone Numbers in Same Cell

    Another way. With the understanding that source string is in A1 this formula
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Dave

  4. #4
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,396

    Re: Multiple Phone Numbers in Same Cell

    Or just use TEXTSPLIT and format outputs as Special >> telephone number

  5. #5
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,093

    Re: Multiple Phone Numbers in Same Cell

    Options:

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Formula: copy to clipboard
    Please Login or Register  to view this content.
    with Custom Format "(###) ###-####" (no quotes)

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 3
    Last Post: 03-02-2023, 05:57 AM
  2. [SOLVED] Phone number format - reference post (Formatting Textbox to type phone numbers only)
    By eddyrcabrera79 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-01-2015, 05:35 PM
  3. searching multiple columns for duplicate phone numbers
    By jim227 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-19-2015, 01:16 PM
  4. Trying to unify multiple different formats of phone numbers
    By Chanu in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-21-2013, 03:16 PM
  5. Convert multiple email and phone numbers into clickable links for mobile Devices
    By kimcole5 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-30-2013, 04:58 AM
  6. Mobile Phone Numbers/ Cell Phones
    By pdiminski in forum Excel - New Users/Basics
    Replies: 10
    Last Post: 02-16-2010, 02:06 PM
  7. Replies: 1
    Last Post: 02-11-2005, 01:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1