+ Reply to Thread
Results 1 to 3 of 3

Change Phone Number With International Dial Code Back To UK Format

  1. 04-18-2018, 07:43 AM #1
    RedMacLeod
    RedMacLeod is offline
    Registered User
    Join Date
    04-18-2018
    Location
    Brighton, UK
    MS-Off Ver
    2016
    Posts
    2

    Change Phone Number With International Dial Code Back To UK Format

    I have a column of telephone numbers, which have not been input in a standard format. Some start with the international dial code 0044 and some 44.
    I need them to be the UK format, starting with just a zero.

    00441234567890
    441234567890
    01234567890

    Result: 01234567890

    Thank you in advance for any assistance.
    Reply With QuoteRegister To Reply
  2. 04-18-2018, 07:50 AM #2
    samba_ravi
    samba_ravi is online now
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,915

    Re: Change Phone Number With International Dial Code Back To UK Format

    Try
    ="0"&RIGHT(TRIM(SUBSTITUTE(A1,CHAR(160),"")),10)
    and copy towards down
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.
    Reply With QuoteRegister To Reply
  3. 04-18-2018, 09:06 AM #3
    RedMacLeod
    RedMacLeod is offline
    Registered User
    Join Date
    04-18-2018
    Location
    Brighton, UK
    MS-Off Ver
    2016
    Posts
    2

    Re: Change Phone Number With International Dial Code Back To UK Format

    It works. Thank you for such a quick response.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Change the phone number format to unique
    By sjpras in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-11-2015, 04:47 AM
  2. I need a VBS code that change a phone number to the name of the owner
    By zitno in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-08-2014, 04:47 PM
  3. Change Phone number format
    By genefalk1 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 08-26-2014, 10:43 PM
  4. Is it possible to make Excel dial a phone number from my smart phone?
    By D_Step in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 06-19-2013, 06:11 PM
  5. Excel can dial a phone number??
    By msjoy in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-24-2012, 01:17 PM
  6. [SOLVED] Using Acces or Excel How Can I create a Raido Button or Something to Click on to Dial a Phone Number?
    By Mike in forum Excel General
    Replies: 2
    Last Post: 06-25-2006, 10:45 PM
  7. Format change of phone number
    By helpjim in forum Excel General
    Replies: 7
    Last Post: 05-18-2006, 02:34 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1