一个表格拆分二个表格_如何在Google表格中拆分文本

一个表格拆分二个表格

Often, you need to split the content of a cell in your spreadsheet that is separated by a comma or space, such as the first and last names of a contact. Luckily, Google Sheets provides a simple, straightforward approach to dealing with merged datasets.

通常，您需要拆分电子表格中用逗号或空格分隔的单元格的内容，例如联系人的名字和姓氏。 幸运的是，Google表格提供了一种简单直接的方法来处理合并的数据集。

如何在Google表格中拆分文本 (How to Split Text in Google Sheets)

Fire up your browser, open up a Google Sheets document, and select all the cells you want to split up.

启动浏览器，打开Google表格文档，然后选择要拆分的所有单元格。

Warning: Make sure the cells to the right don’t already have data in them. This feature overwrites those cells without any warning.

警告：确保右侧的单元格中没有数据。 此功能将覆盖这些单元，而不会发出任何警告。

Next, click Data > Split Text Into Columns.

接下来，单击数据>将文本拆分为列。

Sheets has a few common options to choose from when you split up data in your document, such as by comma, semicolon, full stop, and space. For this example, we’ll use “Space” as a separator, since there is a space between our datasets.

在拆分文档中的数据时，Sheets有一些常用选项可供选择，例如，逗号，分号，句号和空格。 在此示例中，我们将使用“空格”作为分隔符，因为数据集之间存在空格。

Click the drop-down menu, then choose “Space” from the list of delimiter options.

单击下拉菜单，然后从定界符选项列表中选择“空格”。

Immediately, the data is separated and placed into the column beside the original.

立即将数据分离并放入原始数据旁边的列中。

If your data separates by something other than the options provided, don’t worry. You can use the “Custom” option to specify any character you want.

如果您的数据与提供的选项分开，请别担心。 您可以使用“自定义”选项指定所需的任何字符。

When selecting a separator from the drop-down menu, choose “Custom” instead.

从下拉菜单中选择分隔符时，请选择“自定义”。

Then, in the provided text field, input the character(s)* you want to separate by in your datasets.

然后，在提供的文本字段中，输入要在数据集中分隔的字符*。

*One caveat to this method is the inability to separate data if it contains two different characters. For that, you will need to use Sheet’s built-in SPLIT function, which we’ll cover down below.

*此方法的一个警告是，如果包含两个不同的字符，则无法分离数据。 为此，您将需要使用Sheet的内置SPLIT函数，我们将在下面进行介绍。

Voila! The custom separator removed all instances of “@” in your cells.

瞧！ 自定义分隔符删除了单元格中所有“ @”实例。

如何使用分割功能分割文字 (How to Split Text Using the Split Function)

While the previous feature only lets you specify an exact delimiter to separate, the SPLIT function lets you specify any number of them for a dataset. For example, let’s say your data is an email address and you want to extract the username, sub-domain, and top-level domain into three columns.

尽管以前的功能仅允许您指定一个确切的分隔符，但SPLIT函数可以为数据集指定任意数量的分隔符。 例如，假设您的数据是一个电子邮件地址，并且要将用户名，子域和顶级域提取到三列中。

Select an empty cell, type =SPLIT(G14, "@."), where “G14” is the starting cell. Hit Enter.

选择一个空单元格，键入= SPLIT ( G14 , "@." ) ，其中“ G14”是起始单元格。 按下Enter键。

By default, each character of the delimiter in quotes is individually considered, unlike the previous method, which would look for “@.” in the string and return an unchanged dataset.

默认情况下，与以前的方法将查找“ @”不同，引号中的分隔符的每个字符都是单独考虑的。 在字符串中，并返回未更改的数据集。

Next, double-click the blue square to apply this function to the remaining cells.

接下来，双击蓝色方块以将此功能应用于其余单元格。

The function does its magic and neatly removes the separators from your data.

该函数发挥了魔力，并巧妙地从数据中删除了分隔符。

---

---

That’s all there is to it. Now you can utilize the splitting power of Google Sheets to separate your data into different cells in your spreadsheet.

这里的所有都是它的。 现在，您可以利用Google表格的拆分功能将数据分为电子表格中的不同单元格。

翻译自: https://www.howtogeek.com/415512/how-to-split-text-in-google-sheets/

一个表格拆分二个表格