Count No.of Commas in excel column values

TestingDriveThru: Challenge from last week and How I dealt with it.

Challenge: Count No.of Commas in excel column values

Initially, the challenge does look like simpler. But the challenging part is to count commas if the column values contains more than 500+ commas.

So, I have used excel formula: Which can calculate no. of commas in the column value.

Excel Formula:  =LEN(A1)-LEN(SUBSTITUTE(A1,",","")) 

This entry was posted in . Bookmark the permalink.

Leave a Reply