finnstone
asked on
need formula to count the number of letters in the 2nd word of excel value
example
A J Schreiber
result = 1, for the letter J which is 2nd workd
A J Schreiber
result = 1, for the letter J which is 2nd workd
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Try this and change any nth word in (2-1):
=IF(A1="","",LEN(TRIM(MID(SUBSTITUTE(A1," ",REPT(" ",LEN(A1))), (2-1)*LEN(A1)+1, LEN(A1)))))
=LEN(TRIM(MID(A1,FIND("|",