如果您有一个包含商店库存或类似内容的电子表格^{(spreadsheet)}，并且您需要计算单个单元格中的逗号分隔值，那么您可以通过以下方式完成工作。您可以使用一个简单的函数将所有逗号分隔值的数量放在一个单元格中，而无需任何手动操作。

假设有人向您发送了一个电子表格，其中包含产品、价格等项目。您需要创建一个新列来说明有多少产品已送达您，以便您将事情弄清楚。在这种情况下，您可以使用本指南。

计算^(Count)单个单元格中逗号分隔值的数量

要计算Excel^(Excel)和Google 表格^{(Google Sheets)}中单个单元格中逗号分隔值的数量，您需要按照以下步骤计算单个单元格中的值 -

1. 使用Excel^(Excel)或Google表格打开电子表格
2. 选择一个单元格并输入一个函数

详细指南如下所述。

有一个简单的功能可以在瞬间完成这项工作。无需安装工具或从任何第三方服务或软件获得帮助。

您需要打开电子表格。您可以使用Microsoft Excel或Google 表格^(Sheets)来执行此操作。之后，选择要在其中显示所有逗号分隔值的数量的单元格。

然后，使用以下功能 -

=LEN(TRIM(A1))-LEN(SUBSTITUTE(TRIM(A1),",",""))+1

请^(Please)注意，上面提到的函数会显示 A1 单元格的所有逗号分隔项的数量。您需要更改单元格编号以计算不同单元格的项目。

虽然这个公式在Excel和Google Sheets中运行顺畅，但也有一个缺点。您每次都需要更改手机号码。这就是为什么使用此功能非常耗时的原因。但是，如果您只有十或二十行，您可以使用此公式来完成您的工作。

Count comma separated values in a single cell in Excel and Google Sheets

If yoυ have а spreadsheet containing the stocks in a shop or something similar, and you need to count the comma-separated values in a single cell, here is how you can get the job done. There is a simple function that you can use to put the number of all comma-separated values in a single cell without any manual work.

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-

1. Open spreadsheet with Excel or Google Sheets
2. Select a cell and enter a function

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-

=LEN(TRIM(A1))-LEN(SUBSTITUTE(TRIM(A1),",",""))+1

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.

Related posts

• 如何在Excel and Google Sheets中显示Current Date and Time

• 如何在Excel and Google Sheets中创建下拉列表

• 如何使用Excel连接Google Sheets

• 如何在Excel and Google Sheets中制作弯曲的line graph

• 最好的Google Sheets and Excel Online Calendar templates

• 如何在 Excel 中隐藏工作表、单元格、列和公式

• 如何在Microsoft Excel中使用HLOOKUP function

• 通过Google Drive创建直接链接到Google Sheets PDF链接

• 如何在Google Sheets Quickly Wrap Text？

• 如何在Excel spreadsheet中插入Dynamic Chart

• 如何在Excel中使用Percentile.Exc function

• 如何分割Text给Columns在Excel and Google Sheets

• 如何在Excel formula中锁定单元格以保护它们

• 在 Excel 中链接工作表和工作簿之间的单元格

• Google表格中的10个有用公式可节省您的时间

• 14 个日常使用的实用 Google 表格模板

• 如何在Excel中使用Automatic Data Type feature

• 如何在Google Sheets Web应用程序中旋转文本

• 在没有Google Workspace subscription的情况下创建一个Google Sheets模板

• 如何使用NETWORKDAYS function在Excel