Function or method

  • Thread starter Thread starter Eric Marple
  • Start date Start date
E

Eric Marple

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?
 
Hi Eric,

=CHAR(A1+64)


--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Counting Criteria Values with For Loop 3
Excel Convert word into numbers and back 4
Need a method or function 2
Range passed to a function - trying to just move through the range 4
Anyone Else Facing Public Folder Migration Errors in Exchange? 0
Find all possible combinations of unique letters 3
Set non-continuous PrintArea via Function / Name 0
Excel EXCEL - Set non-continuous PrintArea via Function / Name 0

Back
Top