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/
