| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
CHAR funtcion with double letter columns
Try this UDF
Function CLetter(CNumber As Integer) As String CLetter = Left(Cells(1, CNumber).Address _ (False, False), 1 - (CNumber 26)) End Function call it with =cletter(n) Mike "ellebelle" wrote: 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) | |||
Threaded Mode
