People often need to conceal comma in text when working with documents. Unfortunately, few programs provide the tools you need to accomplish this task. To do something like this typically requires changing between several software packages, which take time and effort. Luckily, there is a solution that suits almost any job: DocHub.
DocHub is a professionally-developed PDF editor with a full set of helpful features in one place. Editing, approving, and sharing forms gets simple with our online tool, which you can access from any online device.
By following these five simple steps, you'll have your modified text rapidly. The user-friendly interface makes the process quick and productive - stopping switching between windows. Try DocHub now!
hello friends welcome to dp tutorials please subscribe to dp tutorials and click on the bell icon for notifications in this tutorial let us learn about how to count number of comma separated values in a cell in excel let us consider this example where we have got some comma separated entries in each cell in the helper column first let us count the number of commas and then add one to these results to get the desired answer okay in cell c5 i type the formula as equals to length open the bracket select the cell a5 close the bracket minus len open the bracket substitute open the bracket a5 comma give inverted commas and a comma inside comma and inverted quotes close the bracket for the substitute and again close it for the length function okay and press enter to see the result as 3 as we have got 3 commas in the cell a5 you got it now in cell e5 you can add 1 to this result to get the number of values in cell a5 like this now drag this formula till the last row and you can observe the res