display one letter of a word in a cell

[r_chaud]

Say I have a Cell J2 that contains the Word "Othello" in it.

Now i have cells A2-H2 and i want each one of those cells to display ONLY
one letter of the word contained in J2 as in:

A2 would display the "O", B2 would display the "t", CB2A2 would display the
"t", D2 would display the "h" and so on

How would i do this?

I tried the Left and RIGHT functions but when i type =left(j2.2) in B2 it
displays the frst and second letter "Ot" but i only want the t to display.

Can anyone help?

 

[Luke M]

You were on the right track, try using the MID function.

A2: "=MID(J2,1,1)
B2: "=MID(J2,2,1)
C2: "=MID(J2,3,1)

etc.

 

[Ron Coderre]

Try this:

A2: =IF(COLUMNS($A:A)>LEN($J2),"",MID($J2,COLUMNS($A:A),1))

Copy that formula across through H2

Does that help?
Post back if you have more questions.
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)