display one letter of a word in a cell
 

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?

display one letter of a word in a cell
 

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.


--
Best Regards,

Luke M


"r_chaud" wrote:

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?

display one letter of a word in a cell
 

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)

"r_chaud" wrote in message
...
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?