| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to extract just the Column Name of the active cell
It doesn't update very well, but...
=CHAR(CELL("col")+64) "Fred" wrote: Hello, Does anyone know how to extract only the Column Name of an active cell in another cell. e.g. If active cell is D4 then I want the "D" to be extract and displayed in another cell say A1. Let me know. Regards, Fred |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF/AND/OR/DATEIF Issue...sorry...long post... | Excel Worksheet Functions | |||
| creating a bar graph | Excel Discussion (Misc queries) | |||
| Find a empty cell in next column | Excel Discussion (Misc queries) | |||
| Unable to set the active cell from VBA | New Users to Excel | |||
| GET.CELL | Excel Worksheet Functions | |||
Threaded Mode
