Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
display a letter in a chart | Charts and Charting in Excel | |||
formatting a cell to display a word when i enter a reference lette | Excel Discussion (Misc queries) | |||
Default Capital letter for 1st letter of a word | Excel Discussion (Misc queries) | |||
I want to type the letter Y in a cell and have the word Yes appea. | New Users to Excel | |||
have cell display the word balance when a equals the same amount a | Excel Discussion (Misc queries) |