+ Reply to Thread
Results 1 to 4 of 4

How to take split a two digit cell into two separate cells.

  1. #1
    Forum Contributor
    Join Date
    08-07-2012
    Location
    US
    MS-Off Ver
    Excel 2010
    Posts
    202

    How to take split a two digit cell into two separate cells.

    Hey ya'll. I've tried about a million different combinations of formulas to do what I'm needing here and I know it is way simpler than I'm making it.

    I know how to split a cell that has a double digit number into two separate cells. I have one cell that will take the left digit and another that will take the right digit. My problem is, if the data cell has only one digit, I need the right to take it, but the left to be 0.

    Say C2 is the number 23. I need C3 to take the left 2 and D3 to take the right 3. That part I got.

    But say C2 is 7. I need C3 to be 0 and D4 to be the 7.

    I'm really only needing a formula for C3 that takes the left number. D3 will always take the right, so it's good to go.

    Here is the formula I'm using for C3, and I think there's a way to add to it if there is no left, to just place a 0 there. I'm not sure.
    =LEFT(C3)+0

    I know it's something simple, it's just eluding me like crazy. Any ideas???? Much great thanks in advance!!!!

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: How to take split a two digit cell into two separate cells.

    In C2, =int(b2/10)

    In D2, =mod(b2, 10)
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Forum Contributor
    Join Date
    08-07-2012
    Location
    US
    MS-Off Ver
    Excel 2010
    Posts
    202

    Re: How to take split a two digit cell into two separate cells.

    B E A U T I F U L ! ! ! ! ! !

    I knew it would be something simple. Especially for you guys!!!! Your the best bunch of teachers alive!!!!!!

    THANK YOU shg!!!!!!!

    Worked like a charm...............

  4. #4
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: How to take split a two digit cell into two separate cells.

    You're welcome

+ 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