+ Reply to Thread
Results 1 to 4 of 4

Opposite of concatenate / adding in extra info to a large number

  1. #1
    Registered User
    Join Date
    05-26-2011
    Location
    London, England
    MS-Off Ver
    Excel 2013
    Posts
    71

    Opposite of concatenate / adding in extra info to a large number

    I have cells with a string of numeric characters in it (i.e. 12345678) and I want to split it, in one cell, to read as 123.456.78
    Can anybody please tell me if this is possible?
    Thanks!

  2. #2
    Forum Contributor
    Join Date
    01-28-2010
    Location
    Riverside, CA
    MS-Off Ver
    Excel 2010
    Posts
    132

    Re: Opposite of concatenate / adding in extra info to a large number

    If your cells always have the same number of digitals, change A1 to the cell your number is in:

    Please Login or Register  to view this content.
    Last edited by haru; 04-04-2012 at 04:10 PM.
    Happy Excel'ing!

  3. #3
    Valued Forum Contributor
    Join Date
    04-03-2012
    Location
    East Sussex, UK
    MS-Off Ver
    Excel 2003:2010
    Posts
    893

    Re: Opposite of concatenate / adding in extra info to a large number

    If your original number is in A1, enter the following into the cell you want the amended version in:

    =LEFT(A1,3)&"."&MID(A1,4,3)&"."&RIGHT(A1,2)

    I'm sure there are prettier ways of managing this, but it does the job for now.

    EDIT: I think Haru is reading my mind!!!!

  4. #4
    Registered User
    Join Date
    05-26-2011
    Location
    London, England
    MS-Off Ver
    Excel 2013
    Posts
    71

    Re: Opposite of concatenate / adding in extra info to a large number

    Thanks people, much appreciated!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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