Thread: Need formula to increase Alpha character to next letter
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Niek Otten Niek Otten is offline
external usenet poster
  
Posts: 3,440
Default Need formula to increase Alpha character to next letter
=CHAR(CODE(A2)+1)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"pwinters" wrote in message
...
I am looking for a formula that will increase by one letter the alpha
designation in a column. ex. A2 would be the letter 'A', B2 which would
show
the next letter of the alphabet should be 'B'. I know how to increase a
number, ex. =(A2+1), how do I do the alphabet?

Reply With QuoteReply With Quote