Typing into excel, 1 cell per character

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" <[email protected]> wrote in
message news:[email protected]...
>
> 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?
>
> Thanks
>
> Nitesh
>
>
> --
> Snook
> ------------------------------------------------------------------------
> Snook's Profile:
> http://www.excelforum.com/member.php...o&userid=26306
> View this thread: http://www.excelforum.com/showthread...hreadid=395800
>

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.
--
Earl Kiosterud
www.smokeylake.com

"Earl Kiosterud" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in
> message news:[email protected]...
>>
>> 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?
>>
>> Thanks
>>
>> Nitesh
>>
>>
>> --
>> Snook
>> ------------------------------------------------------------------------
>> Snook's Profile:
>> http://www.excelforum.com/member.php...o&userid=26306
>> View this thread:
>> http://www.excelforum.com/showthread...hreadid=395800
>>
>
>