Excel Forum
Similar Content
SUBSTITUTE() Function - Change Specific Text within a Cell in Excel
Tutorial: Change or replace text in a cell with other text - you can replace a single character, num...
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...
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course



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.