View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Polos Polos is offline
external usenet poster
 
Posts: 1
Default Convert Column Letters to Number

Hi!

I'm looking for a function to convert a "large" column letters (up t
10 characters) to it's equivalent in number.

e.g.

Input=A
Output=1

Input=AAA
Output=703

Input=EXCEL
Output=2,708,874

Any suggestions?

Regards

--
Message posted from http://www.ExcelForum.com