Using letter to count like binary

Hi Mathieu,

Kind of like an outline sequence but without capitals or numbers.

I think you could do the following using worksheet functions.

=if(trim(a1)="","",left(trim(a1)&"000000",6))

as programming code you could do the same type of thing.

HTH,

David McRitchie, Microsoft MVP - Excel

My Excel Macros: http://www.geocities.com/davemcritchie/excel/excel.htm

Search Page: http://www.geocities.com/davemcritchie/excel/search.htm

Quote:

> Hi World

> I need help on trying to make the alphabet count like binary in Excel.

> Would you help me please. Thank you in advance.

> 000 a

> 001 b

> 010 ba

> 011 c

> 100 ca

> 101 cb

> 110 cba

> 111 d

> Mathieu ly

> --

> Posted via CNET Help.com

> http://www.help.com/