在Excel中将文本拆分为列

本文介绍了在Excel中将文本拆分为列的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

我在Excel Online(onedrive站点)中有此表:

I've this table in Excel Online (onedrive site) :

PEOPLE FIRSTNAME LASTNAME AGE ID DETAILS DETAILS DETAILS

我想在此处复制文本行，并将其全部填充到适当的行中.

I would like to copy there lines of text and that it all will be filled into the appropriate rows.

for example, Mariah Carey 30 5555 Marc Terenzi 31 7777

将通过以下方式填写表格:

will fill the table by:

PEOPLE FIRSTNAME LASTNAME AGE ID DETAILS Mariah Carey 30 5555 DETAILS Marc Terenzi 31 7777

假设每个全名仅包含两个名称，那么"(空格)可以作为新单词的指示.

Assuming that each full name contains only two names so " " (a space) can be an indicator for the new word.

我该怎么办?

推荐答案

将值粘贴到FIRSTNAME列中(是，数据将在一个单元格中)

选择带有值的单元格.

转到您的Data标签.

点击Text To Columns.

选择Delimited选项.

选择Space作为分隔符.

点击Finish

Paste the values in the column FIRSTNAME (Yes, data will be in one cell)

Select the cells with the values.

Go to your Data tab.

Click on Text To Columns.

Choose Delimited option.

Select Space as separator.

Click Finish