How to express number of Characters for a formula

[mstuf]

Good Evening --

Could Someone help me to express the value I need to specify for a formula that I am trying to write in cell BD1

Heres what I am trying to do.

=IF(AK1<b>=< 11 Characters</B>,"ISBN"),IF(AK1<b>=> 11 Characters</b>,"UPC")

for the 11 Characters value - I have tried to use *********** and ???????????

The Characters in AK1 are Numbers with an occasional letter at the end of a few but they are stored as Text so that numbers that open with 0's are not truncated.


Your Input would be appreciated much. I'm stumped

Thanks

 

[Sal Paradise]

=if(len(ak1)=<11,"isbn","upc")

 

[hkaplan2]

Something like:

=IF(LEN(AK1)=<11,"ISBN","UPC")

 

[mstuf]

SWEET !
Thanks So Much

Might just be Excel 2002 but it wanted =IF(LEN(AK1)<=11,"ISBN","UPC")

<= instead of =<

I found some nice tutorials lately online but LEN wasnt covered there --

Again -- BIG THANKS