Excel Pro Trick: Count Comma Separated values in a Single Cell in Excel
Excel Tutorial: Count Comma or Semi-Colon Separated Values in a Single Cell with LEN and SUBSTITUTE Functions. Discover the easy way to count the occurrence of text values in a string in a single cell using LEN and SUBSTITUTE functions in Excel. This tutorial will show you how to count comma separated values in Excel, as well as semi-colon separated values.
Start using LEN and SUBSTITUTE for all your Excel needs today!
Subscribe to Our Channel @KDJayakody for watching more pro tips and tricks.
#excel #easy #shorts