Let’s assume that someone has sent you a spreadsheet which has items like products, price, etc. You need to make a new column to mention how many products have reached you so that you can clear things up. For such times, you can use this guide.
Count number of comma-separated values in a single cell
To count the number of comma-separated values in a single cell in Excel & Google Sheets, you need to follow these steps to count the value in a single cell- The detailed guide is mentioned below. There is a simple function that does the job within moments. There is no need to install a tool or take help from any third-party service or software. You need to open the spreadsheet. You can use Microsoft Excel or Google Sheets to do that. After that, select a cell where you want to display the number of all comma separated values. Then, use the following function-
Please note that the function mentioned above would display the number of all comma separated items of A1 cell. You need to change the cell number to count the items of a different cell. Although this formula works smoothly in Excel and Google Sheets, there is a drawback. You need to change the cell number every time. That is why using this function is quite time-consuming. However, if you have only ten or twenty rows, you can use this formula to get your job done.
