Type 3 digits in one cell then automatically move to next cell.

[Guest]

I am working in a spreadsheet where I am transfering numbers from paper. Each
cell has a set amount of digits. For example the first cell is a 3 digit
number. The next a 4 digit number, then a 2 digit number.

Is there anyway I can set it up just like some web pages that have phone
numbers, so that when I input the 3 digit number the cursor jumps to the next
cell, then input the 4 digits, jumps to the next cell and I put in the 2
digit number.

Thanks for the help.

 

[Biff]

No. You have to hit some key to let Excel know you're done typing in a cell.
Those keys are: Enter, Tab, one of the directional arrow keys or ESC.. Until
you hit one of those keys Excel is in Edit mode and nothing else can happen
until you are out of Edit mode.

Biff

 

[Biff]

No. You have to hit some key to let Excel know you're done typing in a

cell. Those keys are: Enter, Tab, one of the directional arrow keys or
ESC..

In addition, you can use your mouse to click on another cell.

Biff

 

[Guest]

I don't believe this is possible. One thing you could do however, is enter
all numbers for each line into one cell. Then, when you're done, use
"Text-To-Columns" to seperate the numbers into their appropriate cells.

HTH,
Elkar

 

[Dave Peterson]

Maybe you could try this:

Tools|Options|Edit tab|Move selection after enter|change to Right
Then select your 3 column Range (say A1:C99)
Hit the Number lock key
Use the numbers on the number keypad and when you're done with one cell, hit the
enter key.

It's not quite the same, but it might be a quicker way to enter all your data.

---
Another alternative.
Select a single column (Say A1:A99)
Format that column as Text (format|cells|Number tab|Text)
type your numbers in with no spaces (all 9 digits)

Then use formulas to extract each portion:

=left(a1,3)
=mid(a1,4,4)
=right(a1,2)