Excel Forum
Similar Content
WEEKNUM UDF for Excel Versions That Don't Contain This Function - UDF
Macro: This is a WEEKNUM UDF for Excel. This allows you to determine the number of the week ...
Formula to Count Occurrence of Specific Characters in a Cell
Tutorial: Formula that counts the occurrences of a specific character in a cell in Excel. This tutor...
Formula to Delete the First or Last Word from a Cell in Excel
Tutorial: Excel formula to delete the first or last word from a cell. You can copy and paste the for...



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.