TestingDriveThru: Challenge from last week – 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,”,”,””)) 


Source: ministry of testing
TestingDriveThru: Challenge from last week – Count No.of Commas in excel column values

Share This Post

Show Buttons
Hide Buttons