+ Reply to Thread
Results 1 to 3 of 3

Adding space between a range of numbers

  1. 03-06-2012, 03:51 AM #1
    pukindog is offline
    Registered User
    Join Date
    03-06-2012
    Location
    Singapore
    MS-Off Ver
    Excel 2003
    Posts
    2

    Adding space between a range of numbers

    Hi,

    I would like to leave a space in between a range of number. The location of the space is fixed. Please see example

    1111968712345898 to 1111 9687 1234 5898. Please note the format type is text and i won't want to change it to number as it would round of the last digit.

    Any help would be appreciated from any kind soul.
    Reply With QuoteRegister To Reply
  2. 03-06-2012, 03:53 AM #2
    Andrew-R is offline
    Forum Expert
    Join Date
    07-16-2010
    Location
    Northumberland, UK
    MS-Off Ver
    Excel 2007 (home), Excel 2010 (work)
    Posts
    3,054

    Re: Adding spave between a range of numbers

    If your number is currently in A1 then in another cell try:

    =LEFT(A1,4) & " " & MID(A1,5,4) & " " & MID(A1,9,4) & " " & RIGHT(A1,4)
    Reply With QuoteRegister To Reply
  3. 03-06-2012, 04:06 AM #3
    pukindog is offline
    Registered User
    Join Date
    03-06-2012
    Location
    Singapore
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Adding spave between a range of numbers

    Thanks work perfectly
    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)

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