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

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/

Polos

Check out Myrna's answer in the other news group you posted to.

Gord Dibben Excel MVP

On Tue, 14 Sep 2004 15:59:02 -0500, Polos
wrote:

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/