Simple to calculate the number of spaces of text string in EXCEL with following formula:
=LEN(A1) - LEN(Substiture(A1," ",""))
Above formula will count all the spaces in the text.
Count the number of leading spaces of text string with formula
=FIND(LEFT(TRIM(A2),1),A2)-1
No comments:
Post a Comment
Your feedback is always appreciated. I will try to reply to your queries as soon as time allows.Please don't spam,spam comments will be deleted upon reviews.