Course Content

Course Content

Split Data in MS Excel

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.


Select the text you want to split. Select Data > Text to Columns. Select the Delimited > Next option. Choose the delimiters that will separate your columns of data, then select Next. Choose the destination where your data will be saved, and click OK. Spilt data in Excel makes it easy to split the text into individual cells or columns based on a delimiter. You can also use this tool to convert a column of text into a number of rows.

The advantages of using Excel to separate first and last name is that it makes it easier for people to fill in forms accurately when they have a hard time remembering their own names. It also helps people avoid duplicating entries in their address books or phone contacts.In Microsoft Excel, you can separate the first and last names. By separating the first and last name, you can easily search or filter for a specific person in a list of data. In order to find data that belongs to a specific person, you need to be able to search for their name separately from other data in the spreadsheet. This is especially useful for searching for people by name in a list of data. However, there are some use cases where it can be inconvenient or even not possible to separate the first and last name of a person in a spreadsheet. For example, if you want to use Firstname Lastname as an identifier that will always be there regardless of how many rows or columns your spreadsheet goes into.To separate the first and last names in Excel, use this formula in any cell of your desired row: =DATEVALUE("yyyy"&ROW()-1, "mm") For example, if you want to separate Joe Smith’s name into Joe Smith, then the formula would be: =DATEVALUE("yyyy"&ROW()-1, "mm")&"-"&DATEVALUE("dd", "mm") In this case, "-" is a dash symbol.

A cell is a region of space that can be filled with data. It is the smallest unit of data in Excel. Cells are created by selecting any cell on the worksheet, then clicking or tapping on the button that looks like an oval with a small square in its center. Excel will split cells differently depending on whether you select them by clicking or tapping on them. When you click on a cell, Excel will split it into two cells; it will create one cell containing the data to the left of where you clicked and another containing all of your data to the right of where you clicked. When you tap anywhere in a cell, Excel will give you four options: - Copy (it creates two new cells), - Paste (it takes your text from one cell

Recommended Courses

Share With Friend

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

Download LearnVern App

App Preview Image
App QR Code Image
Code Scan or Download the app
Google Play Store
App Store
397K+ Downloads
App Download Section Circle 1
4.57 Avg. Ratings
App Download Section Circle 2
13K+ Reviews
App Download Section Circle 3
  • 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