Results 1 to 6 of 6

Parenthesis Help

Threaded View

  1. #1
    Registered User
    Join Date
    09-03-2014
    Location
    South Africa
    MS-Off Ver
    MS Office 2010
    Posts
    40

    Parenthesis Help

    Good Day,

    I am looking for help on extending/adjusting my current formula.

    Currently I am using : =REPLACE("("&LEFT(A1,3)&") "&RIGHT(A1,LEN(A1)-3),10,,"-")

    to do the following:

    A B
    1 0436423447 (043) 642-3447


    I now want help to do more or less the same, as per example below.

    A B
    1 0436123456 0431234567 (043) 612-3456 (043) 123-4567


    Any suggestions?Attachment 384324
    Attached Files Attached Files
    Last edited by Helgard25; 03-20-2015 at 06:46 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Keep only text between parenthesis
    By aharvestofhealth in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-10-2015, 01:58 PM
  2. Parenthesis Help with SQL in VBA
    By jo15765 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-01-2012, 03:32 AM
  3. Missing parenthesis
    By docrobo in forum Excel General
    Replies: 3
    Last Post: 10-23-2011, 05:18 PM
  4. Parenthesis
    By John Abbot in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-10-2007, 09:49 AM
  5. [SOLVED] Parenthesis
    By GitFinger in forum Excel General
    Replies: 2
    Last Post: 03-31-2006, 10:30 AM

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