excel formula question

say in a1 i have "bird"

what can i put in a2 to count the number of letters in a1 (4)?

thanks

 

=LEN(a1)

which should give you 4. (Note that if a1 contains 123.4, then a2 will equal 5)

 

nice! perfect!

thanks!

 

For the sake of correctness, let me qualify my previous reply by stating that it is true for all cases except when cells a1 and a2 have range names "hand" and "bush" respectively - in this case, =LEN(a1) yields 8, as clearly a "bird" in the "hand" is worth two in the "bush".

 

Nice !