Excel Forum

Excel Magic Trick 289: LEN & SUBSTITUTE functions Counting Tricks

Count Words Separated by Commas with LEN & SUBSTITUTE functions in a formula. Using LEN and SUBSTITUTE we can count the commas in "rad,cool, super" and get two then add one more to get three. This trick is useful because it can help us to count words, numbers or fields in a text string.

This trick is the basis for many other Tricks with Excel Formulas that analyze text strings.

Got a Question? Ask it Here in the Forum.