| 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? |
| 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) | |||
Threaded Mode
