Thread: Column Number from Column Letter
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default Column Number from Column Letter
Try:-

=COLUMN(E1)

Would return 5.

Mike

"Robert" wrote:

I have the column letter of a cell and I need the column number. I know this
must be simple but I cannot figure out how to do it.
--
Robert Hill

Reply With QuoteReply With Quote