MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Only 1 character per cell

Posted by Tim Emery on February 11, 2000 6:03 PM

I need to enter one character per cell, and it would make my job so much
easier if when I enter one character, excel automatically goes to the next
cell to the right. so if i typed 123 it would enter 1 in "a1" 2 in "b1" 3
in "c3" is this possible without me hitting the tab key after every number
or letter?

This would save me a whole lot of time.

Thanks in advance


Posted by JAF on February 14, 2000 3:08 AM

Quick and Dirty Workaround

Type your number as normal in (say) cell A1

Input the following formula in B1:

Input the following formula in C1:

Copy the formula across as many columns as you need, increasing the "middle" number each time, so that in D1 you would have =mid($A1,3,1) and so on.

Posted by Bill Roberts on February 23, 2000 7:18 AM

I've ben thinking about your problem and think I have a solution.

Only problem is that it will be hairy.

Your going to have to write an EVENT HANDLER or MACRO that is always running which will PARSE your input.

That doesn't seem to bad; yet, you'll have to test keystrokes for the occurance of any key (ie, ARROW, PG UP/DN) that interrupts the normal progression of data input.

On top of that, you'll have to analyze the CHARACTER SET if you allow your users to select any other keys besides A-Z.

IT CAN BE DONE but it will be a major problemo.

Reminds me of the DOS programming days when the coder had to anticipate every keyboard press...