在Excel中将文本拆分为列 [英] split text to columns in 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.

我该怎么办?

推荐答案

1. 将值粘贴到FIRSTNAME列中(是，数据将在一个单元格中)
2. 选择带有值的单元格.
3. 转到您的Data标签.
4. 点击Text To Columns.
5. 选择Delimited选项.
6. 选择Space作为分隔符.
7. 点击Finish

1. Paste the values in the column FIRSTNAME (Yes, data will be in one cell)
2. Select the cells with the values.
3. Go to your Data tab.
4. Click on Text To Columns.
5. Choose Delimited option.
6. Select Space as separator.
7. Click Finish

这篇关于在Excel中将文本拆分为列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！