在Excel^(Excel)中随机编译的列表中，数据在第一个单词后缺少逗号是很常见的。从文字编辑器复制数据时尤其如此。要了解如何在每个单元格的第一个单词后添加逗号，请通读这篇文章。

您可以通过两种方法在Excel中每个单元格的第一个单词后添加逗号：

1. 使用复制功能
2. 使用替代功能

有许多公式可以在单元格中的第一个单词后添加逗号。如果您有一个跨列排列的列表，您可以使用“填充^(Fill)”选项在列表中复制公式。

使用Replicate函数在Excel中每个单元格中的第一个单词后添加逗号

使用Replicate函数在^(Replicate)Excel中每个单元格的第一个单词后添加逗号的语法如下：

=REPLACE(<first cell in which you need to add comma>,FIND(" ",<first cell in which you need to add comma>),0,",")

在哪里，

• <您需要在其中添加逗号的第一个单元格> 是列表中您需要在第一个单词之后添加逗号的列中的第一个单元格。

例如。让我们假设我们需要在每个单元格中的第一个单词之后添加一个逗号，以获得姓名列表 + 运动过的人。该列表从 A3 开始，到 A7 结束。我们需要 B 列中的修订列表。

公式将变为：

=REPLACE(A3,FIND(" ",A3),0,",")

在单元格 B3 中输入此公式，然后单击单元格外的任意位置。

现在再次单击单元格 B3 以突出显示“填充^(Fill)”选项并将其下拉到单元格 B8。你会得到想要的结果。

使用Substitute函数在Excel中每个单元格中的第一个单词后添加逗号

使用Substitute函数在^(Substitute)Excel中每个单元格的第一个单词后添加逗号的语法如下：

=SUBSTITUTE(<first cell in which you need to add comma>," ",", ",1)

在哪里，

• <您需要在其中添加逗号的第一个单元格> 是列表中您需要在第一个单词之后添加逗号的列中的第一个单元格。

例如。我们可以使用与之前相同的示例，其中条目列表从单元格 A3 开始。具有Substitute^(Substitute)函数的公式将变为：

=SUBSTITUTE(A3," ",", ",1)

在单元格 B3 中输入此公式，然后再次使用“填充^(Fill)”选项在列中复制该公式。

将其下拉到单元格 B8，然后单击选区之外的任意位置。

我们希望这个解决方案有帮助！

How to add a Comma after first Word in each Cell in Excel

It is vеry common in randomly compiled lists in Excel that the data is missing commas after the first word. This is especially the case when the data is copied from word editors. To find how to add a comma after the first word in each cell, please read through this article.

You can add a comma after the first word in each cell in Excel by two methods:

1. Using Replicate function
2. Using Substitute function

There are many formulas to add a comma after the first word in a cell. In case you have a list arranged across a column, you can replicate the formula across the list using the Fill option.

Add a comma after the first word in each cell in Excel using Replicate function

The syntax to add a comma after first word in each cell in Excel using the Replicate function is as follows:

=REPLACE(<first cell in which you need to add comma>,FIND(" ",<first cell in which you need to add comma>),0,",")

Where,

• <first cell in which you need to add comma> is the first cell in the list across the column for which you need to add the comma after the first word.

Eg. Let us assume a case where we need to add a comma after the first word in every cell for a list of names + sport played the person. The list starts from A3 and ends at A7. We need the revised list in column B.

The formula would become:

=REPLACE(A3,FIND(" ",A3),0,",")

Enter this formula in cell B3 and click anywhere outside the cell.

Now click on cell B3 again to highlight the Fill option and pull it down to cell B8. You would get the desired result.

Add a comma after the first word in each cell in Excel using Substitute function

The syntax to add a comma after the first word in each cell in Excel using Substitute function is as follows:

=SUBSTITUTE(<first cell in which you need to add comma>," ",", ",1)

Where,

• <first cell in which you need to add comma> is the first cell in the list across the column for which you need to add the comma after the first word.

Eg. We can use the same example as earlier where the list of entries start from cell A3. The formula with the Substitute function would become:

=SUBSTITUTE(A3," ",", ",1)

Enter this formula in cell B3 and again use the Fill option to replicate the formula across the column.

Pull it down to cell B8 and then click anywhere outside the selection.

We hope this solution was helpful!

Related posts

• Excel，Word or PowerPoint上次无法启动

• 如何更改默认File Format，用于保存Word，Excel，PowerPoint

• 如何启动Word，Excel，PowerPoint，Outlook在Safe Mode

• 增加Word，Excel，PowerPoint中最近文件的数量

• 如何在Excel中添加或删除Cell Borders

• 如何在Excel中停止或关闭Workbook Sharing

• 如何在安全模式下打开 Word 和 Excel

• 在 Excel 中拆分单元格的 3 种方法

• 在 Excel 中复制公式时保留单元格引用

• 如何使用NETWORKDAYS function在Excel

• 如何在Microsoft Word and Excel中安装和使用加载项，用于iPad

• 如何在Excel创建和使用Form Controls

• 如何在Excel中创建Organization Chart

• Word，Excel，Excel，Excel，Format Text，Format Text

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

• 如何在Word中启用Dark Mode，Excel and PowerPoint

• Download免费Word，Excel，PowerPoint，Access，Visio Templates

• 如何在Microsoft Excel中使用HLOOKUP function

• 如何在Excel中使用Rept Function

• 如何计算在Excel的Yes or No entries数