MrExcel.com - Your One Stop for Excel Tips & Solutions

Counting letters in a string

Posted by Joe C on September 14, 2001 8:17 AM

I have a msg box which asks a question.
I need to count the letters in the string.
Does such a comand exist.
Thanks for any help

Posted by Barrie Davidson on September 14, 2001 8:58 AM

Try using
LEN(expression)

Regards,
BarrieBarrie Davidson

Posted by Joe C on September 14, 2001 9:15 AM

Thanks, Worked like a charm