| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I get a number or letter to represent cell contents?
I am trying to find a way to have a number or letter represent certain cell
contents so that when I type that number or letter into a new cell it will automatically fill with the represented cell contents. Example: cell A1= Apples and I want 1 to represent the contents in A1 which is Apples so that when I enter 1 into cell A2 the word Apples automatically fills in for cell A2. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Set number format based on cell contents | Excel Discussion (Misc queries) | |||
| Getting contents of a cell when cell reference is in the sheet | Excel Discussion (Misc queries) | |||
| How do I add row total when cell contains both number and letter . | Excel Discussion (Misc queries) | |||
| How do I get a letter in one cell ito equal a number in anotherl.. | Excel Discussion (Misc queries) | |||
| Formatting a cell as "text" in the number catagory. | Excel Worksheet Functions | |||
Threaded Mode
