Individual keystroke as a separate entry?

[Don]

I would like to make each individual keystroke a separate
cell entry-

e.g. If I were to type the phrase:

THIS IS AN EXAMPLE.

I would like this to take up 19 individual cells,
(including the period). Any ideas?

 

[AlfD]

Hi!

One simple way for dealing with a batch would be:
enter the text in A1, A2 etc
use Data > Text to Columns treating your input text as fixed lengt
field : length 1.
It's a bit tedious marking up the fields.

Al

 

[BrianB]

Say you type in cell A1.
Copy this formula from B1 across :-
=MID($A1,COLUMN()-1,1)

When you have done typing, select all the cells with formulas and Copy
Edit/Paste Special/Values

 

[Don]

Thanks ALF,

What I'm trying to do is to frequently 'fill out the same
form' with different data.

This just might work! It would be worth it if I only have
to do it once.

Don

 

[Don]

Brian-
This is an excel-lent formula!
When I type in 1 cell I got every keystroke to drop in an
individual cell, including spaces! I can't seem to figure
out the 'Copy Edit/Paste Special/Values'. When I do that I
get the first letter of whatever I type in EACH cell!???

I guess if I add a 'FRONT COLUMN" to each entry field in
the 'A Column' and move my print area to start at B1 and
over, I can retain the original form.

Thanks for taking the tedium out of my day, guys!

Don

-----Original Message-----
Say you type in cell A1.
Copy this formula from B1 across :-
=MID($A1,COLUMN()-1,1)

When you have done typing, select all the cells with
formulas and Copy Edit/Paste Special/Values.

 

[Brian your suggestion works great....but]

Brian your suggestion works great....but it only works for
the specified area from the NEXT cell over.

If I type in A1 but want the data to start in J1, what I
get is the data in A1 starting 10 letters into my typing!
Is this where the Special Paste is supposed to work?

Sorry- I just don't seem to get it

Don

 

[AlfD]

Hi!

Type Brian's formula in J1 and change the $A into $J.
Copy the formula and paste it across K1 to AZ1 (or however man
characters your text will have).

The copy/paste bit can be done by selecting J1 and finding its past
handle: bottom right of the cell:little square: turns cursor into
cross when you have found it. Drag this across as far as you need to.

Al

 

[AlfD]

Hi!

Change the column()-1 to Column()-9 and put the formula in J1.
The reason is that Column() returns the number of the column it is i
(and Col J is column 10). So column()-9 in J1 gives a value 1 whic
points to the first character of your text in A1.
Then Column()-9 in K1 gives a vcalue of 2 and so on.

Al

 

[Don]

Thanks AGAIN Alf!!!!

DOHHHH.....

Funny how it all seems so simple NOW!!!!
Don