Thread: Convert Column Letters to Number
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Harald Staff Harald Staff is offline
external usenet poster
  
Posts: 1,327
Default Convert Column Letters to Number
This was in a thread at dicks-blog early this summer:

http://www.dicks-blog.com/excel/2004..._letters_.html
http://www.dicks-blog.com/excel/2004..._numbers_.html

.... so I'll not ask you "what's this for" of course <bg

Best wishes Harald

"Polos " skrev i melding
...
Hi!

I'm looking for a function to convert a "large" column letters (up to
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/



Reply With QuoteReply With Quote