Typing into excel, 1 cell per character

  • Thread starter Thread starter Snook
  • Start date Start date
S

Snook

Does anyone know if there is a way to type in excel, so that the
characters are one to a cell.

If I typed hello starting at cell A1, each character would be in cells
A1 to A5.

Without the need to press the right arrow between characters.

Is this even possible? :rolleyes:

Thanks

Nitesh :)
 
Snook

A macro could help, but you'd have to press Enter after each character. Or
you could type the stuff into one cell, and use a formula, copied across:
 
Snook,

Oops. Message disappeared. I hit Send.

A Worksheet_Change macro could do it. But you'd have to press Enter after
each character. Might just as well use the tab key. Or you could type all
the stuff into one cell (A5), then use this, copied across. You won't see
it in the cells until you've pressed Enter:

=MID($A$5,COLUMN(),1)

If you want to see it appear as you type, you'll need to use a UserForm,
with some code to do what you want. Or use dozens of OnKey assignments.
Messy.
 
Back
Top