Thread: Need formula to increase Alpha character to next letter
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
pwinters pwinters is offline
external usenet poster
  
Posts: 2
Default Need formula to increase Alpha character to next letter
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