Excel Forum



Excel Magic Trick 468: Count Spaces at Beginning & End of Text String (Array Formula)


See how to Count Spaces at Beginning & End of Text String in an Array Formula that uses these functions: LEN, INDIRECT, ROW, MID, CODE and MATCH.





Got a Question? Ask it Here in the Forum.