Counting the number of letters in a string?

[wtktrichards]

I have a string that could have any number of letters in, what can i use to add up the number of letters (in VBA)
Thanks
Will

 

[Norie]

Will

If you just want to get the length of a string use Len.

strTest = "TestString"
MsgBox Len(strTest)

Or do you mean there might be a mixture of letters and other characters?

 

[wtktrichards]

Actually it could contain numbers and spaces.

 

[Domenic]

A formula approach...

=COUNT(1/(ABS(CODE(MID(UPPER(A2),ROW(INDEX(A:A,1):INDEX(A:A,LEN(A2))),1))-77.5)<=12.5))

...confirmed with CONTROL+SHIFT+ENTER, not just ENTER.

Hope this helps!