ExcelBanter - Function or method

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Function or method (https://www.excelbanter.com/excel-programming/306115-function-method.html)

Eric Marple

Function or method

Is there a function or method were I can pass in number
and get its letter. Example 1 = A, 2 = B , 3 = C and so
forth?

Niek Otten

Function or method

Hi Eric,

=CHAR(A1+64)

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"Eric Marple" wrote in message
...
Is there a function or method were I can pass in number
and get its letter. Example 1 = A, 2 = B , 3 = C and so
forth?

All times are GMT +1. The time now is 10:33 PM.