| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can I enter a "Y" and return "Yes" in the same cell? PART 2
Last week I asked the question above and I got a couple great responces.
However, the programming response allowed me to only deal with one column and I need to be able to enter a "Y" into any cell within 2 columns in the worksheet and have it return in the same cell the word "YES". Can someone please help me? It was also suggested that I have the auto fill turned on and I would only have to type the word "YES" once then "Y" and enter after that. This doesn't seem to work in all areas of the worksheet. I end up having to type the whole word in each section of the worksheet. Am I missing a setting or something? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If part of a cell = "NVA" then insert "Norfolk" in return cell | Excel Worksheet Functions | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
| Help!!! Enter "7" in a cell and Excel changes the "7" to "11" immediately!!! | Excel Discussion (Misc queries) | |||
| Can I enter a "Y" in a cell and have it return a "YES"? How? | Excel Programming | |||
Threaded Mode
