+5 votes
218 views
How to separate text in columns Excel 2019, Excel 2016

in Office by (552k points)
reopened | 218 views

1 Answer

+3 votes
Best answer

How to separate text into columns in Microsoft Excel 2019, 2016

Microsoft Excel is one of the most complete applications for the entire process of large amounts of data, whether numerical, text or date. This management is possible thanks to the number of functions and formulas that are integrated by default within Excel with which the task is simplified and the possibility of errors is reduced. There are hundreds of actions that we can perform in the cells of an active Excel 2016 or 2019 sheet. One of them is to place the text in one or more cells and divide it into several cells thanks to the wizard designed to convert text into Excel columns ..

This is ideal if we have data that we have to separate and do it manually would take a lot of time.
TechnoWikis will explain how to perform this process in a comprehensive and functional way in Excel 2019.

Note
This same process applies to Excel 2016.

To keep up, remember to subscribe to our YouTube channel! SUBSCRIBE

How to separate text into columns in Microsoft Excel 2019, 2016

Step 1

For this example we have the following data. Our goal is to separate the full names and assign them in the First and Last Name columns. image
Step 2

To achieve this, we will select the cell or column that contains the text we want to divide. After this we go to the “Data” menu and in the “Data Tools” group we locate the “Text in columns” option: image
Step 3

There the following wizard will be displayed to convert text into columns, there we will select the “Delimited” box and click Next:

image

Step 4

In the next window we will select the delimiters for the data to be divided, independent of the selected one, we can see a preview of them in the “Data preview” window:

image

Step 5

There we click on Next and now we define the column data format or we can also leave the default option of Excel 2016/2019:

image

Step 6

Now, in the "Destination" field we will select the cell where the data will be hosted, in this case B2: image
Step 7

Click on "Finish" to complete the task and the result was as follows: image

It will be that simple to use the integrated Excel wizard to divide text into columns and simplify our data management tasks..


by (3.5m points)
edited

Related questions

+5 votes
1 answer
+3 votes
1 answer
asked Jun 24, 2019 in Office by backtothefuture (552k points) | 209 views
+5 votes
1 answer
+5 votes
1 answer
asked Jun 23, 2019 in Office by backtothefuture (552k points) | 283 views
+4 votes
1 answer
asked Oct 25, 2019 in Office by backtothefuture (552k points) | 284 views
Sponsored articles cost $40 per post. You can contact us via Feedback

Most popular questions within the last 30 days

10,659 questions
10,791 answers
510 comments
3 users