Main Profile

At A Glance

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.
Length: 08:09

Contact

Questions about Excel Magic Trick 289: LEN & SUBSTITUTE functions Counting Tricks

Want more info about Excel Magic Trick 289: LEN & SUBSTITUTE functions Counting Tricks? Get free advice from education experts and Noodle community members.

  • Answer

Ask a New Question