Course Content

Course Content

Description

How to split data into multiple columns

Now we will see that we can split our existing data into multiple columns according to our requirement in MS Excel.

For example we have and column of employee name in which it is with first name and last name both together. But now we want to separate first name and last name into two different columns then we will first insert two column next to employee name column, then we will select that employee name column and then from our DATA tab we will select text to column option.

Inside that we will need to choose the option that how we want to separate our field, separate it with the help of commas or space, or some other fixed process. Then next we will select our separator that is space, and provide with the destination.

This well separate the first name and last name of our employees in two different columns.

FAQs

Recommended Courses

Share With Friend

Have a friend to whom you would want to share this course?

Download The Apps

Code Scan or Download the app
Google Play Store
297K+ Downloads
4.5 Rating
10K+ Reviews
  • Learn anywhere on the go
  • Get regular updates about your enrolled or new courses
  • Share content with your friends
  • Evaluate your progress through practice tests
  • No internet connection needed
  • Enroll for the webinar and join at the time of the webinar from anywhere