+ Reply to Thread
Results 1 to 6 of 6

Automatic skipping

  1. #1
    Malainie
    Guest

    Automatic skipping

    I need to enter an 8 digit number, with one number per cell. It gets old
    having to hit a number, then the tab, then the number...you get my drift. Is
    there anyway to set up a formula or something so that after I enter the one
    number, it automatically jumps to the next cell, etc? (I used to be able to
    set up a skip field on the old keypunch machines programming. Surely there is
    some way I can do this in Excel.

  2. #2
    Biff
    Guest

    Automatic skipping

    Hi!

    Insert a helper column to the left of the eight other
    columns.

    Assume that is column A and you enter this one 8 digit
    number in A2.

    A2 = 12345678

    In B2 enter this formula and copy across to I2:

    =--MID($A2,COLUMN(A:A),1)

    Biff

    >-----Original Message-----
    >I need to enter an 8 digit number, with one number per

    cell. It gets old
    >having to hit a number, then the tab, then the

    number...you get my drift. Is
    >there anyway to set up a formula or something so that

    after I enter the one
    >number, it automatically jumps to the next cell, etc? (I

    used to be able to
    >set up a skip field on the old keypunch machines

    programming. Surely there is
    >some way I can do this in Excel.
    >.
    >


  3. #3
    hrushi
    Guest

    RE: Automatic skipping

    Or u can use following formula also,
    in a2 cell
    =INT(A1/10000000)
    in a3 cell
    =INT(A2/1000000)-B2*10
    in a4 cell
    =INT(A2/100000)-B2*100-C2*10

    like wise.

    This may be more useful incase digit is number

    Regards.

    "Biff" wrote:

    > Hi!
    >
    > Insert a helper column to the left of the eight other
    > columns.
    >
    > Assume that is column A and you enter this one 8 digit
    > number in A2.
    >
    > A2 = 12345678
    >
    > In B2 enter this formula and copy across to I2:
    >
    > =--MID($A2,COLUMN(A:A),1)
    >
    > Biff
    >
    > >-----Original Message-----
    > >I need to enter an 8 digit number, with one number per

    > cell. It gets old
    > >having to hit a number, then the tab, then the

    > number...you get my drift. Is
    > >there anyway to set up a formula or something so that

    > after I enter the one
    > >number, it automatically jumps to the next cell, etc? (I

    > used to be able to
    > >set up a skip field on the old keypunch machines

    > programming. Surely there is
    > >some way I can do this in Excel.
    > >.
    > >

    >


  4. #4
    Jim May
    Guest

    Re: Automatic skipping

    Franks, thanks (as usual) for your input.
    one question... does the "--" preceding the mid()
    statement coerce what would be string values into numeric values?
    Am I saying this right?
    TIA,
    and Happy New Year to you

    "Biff" <[email protected]> wrote in message
    news:[email protected]...
    > Hi!
    >
    > Insert a helper column to the left of the eight other
    > columns.
    >
    > Assume that is column A and you enter this one 8 digit
    > number in A2.
    >
    > A2 = 12345678
    >
    > In B2 enter this formula and copy across to I2:
    >
    > =--MID($A2,COLUMN(A:A),1)
    >
    > Biff
    >
    > >-----Original Message-----
    > >I need to enter an 8 digit number, with one number per

    > cell. It gets old
    > >having to hit a number, then the tab, then the

    > number...you get my drift. Is
    > >there anyway to set up a formula or something so that

    > after I enter the one
    > >number, it automatically jumps to the next cell, etc? (I

    > used to be able to
    > >set up a skip field on the old keypunch machines

    > programming. Surely there is
    > >some way I can do this in Excel.
    > >.
    > >




  5. #5
    Jim May
    Guest

    Re: Automatic skipping

    Excuse,,, just revisited my message.. Biff, you're not Frank
    I suppose I'd just finished an extended Q/A with Frank and
    hadn't reset the variable from Frank to Biff.. LOL
    Still thanks BIFF !!! and the same message applies of course
    to you and yours,
    HAPPY NEW YEAR - 2005 !!


    "Jim May" <[email protected]> wrote in message
    news:vhzBd.21079$jn.16933@lakeread06...
    > Franks, thanks (as usual) for your input.
    > one question... does the "--" preceding the mid()
    > statement coerce what would be string values into numeric values?
    > Am I saying this right?
    > TIA,
    > and Happy New Year to you
    >
    > "Biff" <[email protected]> wrote in message
    > news:[email protected]...
    > > Hi!
    > >
    > > Insert a helper column to the left of the eight other
    > > columns.
    > >
    > > Assume that is column A and you enter this one 8 digit
    > > number in A2.
    > >
    > > A2 = 12345678
    > >
    > > In B2 enter this formula and copy across to I2:
    > >
    > > =--MID($A2,COLUMN(A:A),1)
    > >
    > > Biff
    > >
    > > >-----Original Message-----
    > > >I need to enter an 8 digit number, with one number per

    > > cell. It gets old
    > > >having to hit a number, then the tab, then the

    > > number...you get my drift. Is
    > > >there anyway to set up a formula or something so that

    > > after I enter the one
    > > >number, it automatically jumps to the next cell, etc? (I

    > > used to be able to
    > > >set up a skip field on the old keypunch machines

    > > programming. Surely there is
    > > >some way I can do this in Excel.
    > > >.
    > > >

    >
    >




  6. #6
    Tom Ogilvy
    Guest

    Re: Automatic skipping

    That is what it does - coerces the string into a number

    --
    Regards,
    Tom Ogilvy

    "Jim May" <[email protected]> wrote in message
    news:%yzBd.21084$jn.11591@lakeread06...
    > Excuse,,, just revisited my message.. Biff, you're not Frank
    > I suppose I'd just finished an extended Q/A with Frank and
    > hadn't reset the variable from Frank to Biff.. LOL
    > Still thanks BIFF !!! and the same message applies of course
    > to you and yours,
    > HAPPY NEW YEAR - 2005 !!
    >
    >
    > "Jim May" <[email protected]> wrote in message
    > news:vhzBd.21079$jn.16933@lakeread06...
    > > Franks, thanks (as usual) for your input.
    > > one question... does the "--" preceding the mid()
    > > statement coerce what would be string values into numeric values?
    > > Am I saying this right?
    > > TIA,
    > > and Happy New Year to you
    > >
    > > "Biff" <[email protected]> wrote in message
    > > news:[email protected]...
    > > > Hi!
    > > >
    > > > Insert a helper column to the left of the eight other
    > > > columns.
    > > >
    > > > Assume that is column A and you enter this one 8 digit
    > > > number in A2.
    > > >
    > > > A2 = 12345678
    > > >
    > > > In B2 enter this formula and copy across to I2:
    > > >
    > > > =--MID($A2,COLUMN(A:A),1)
    > > >
    > > > Biff
    > > >
    > > > >-----Original Message-----
    > > > >I need to enter an 8 digit number, with one number per
    > > > cell. It gets old
    > > > >having to hit a number, then the tab, then the
    > > > number...you get my drift. Is
    > > > >there anyway to set up a formula or something so that
    > > > after I enter the one
    > > > >number, it automatically jumps to the next cell, etc? (I
    > > > used to be able to
    > > > >set up a skip field on the old keypunch machines
    > > > programming. Surely there is
    > > > >some way I can do this in Excel.
    > > > >.
    > > > >

    > >
    > >

    >
    >




+ 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