Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
CHAR funtcion with double letter columns
I am using this function:
CHAR(MATCH(P$1,$1:$1,)+64) to get teh column letter, however it does not count double letters past column z. As in AA AB etc. Is there a way to get this? Ellen |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Double quotes when concatenating with CHAR(10) | Excel Discussion (Misc queries) | |||
How do I format a letter in Excell with double strikethrough N? | Excel Discussion (Misc queries) | |||
8500 cells with phone number(7 char.), wishing to add area code (10 char.) | Excel Discussion (Misc queries) | |||
Double Stacked Columns - can it be done? | Excel Discussion (Misc queries) | |||
How do I split 16 char text 'XX XXX= +. X' into 16 columns | Excel Discussion (Misc queries) |