View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
r_chaud r_chaud is offline
external usenet poster
 
Posts: 1
Default 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?