Let us now look at how you can use the split function to separate domain name from URL. Step 6: As soon as you click on the Space button, you will notice the full names getting separated as first name and last name.Īfter this, you’ll have two lists of names separated in the Google Sheets. Moreover, you can also leave the option as Detect automatically in the Separator dialogue box. You’ll need to select the Comma option from the Separator dialogue box. Let’s say you have list of names and they’re separated by a comma. Step 5: A Separator dialogue box will appear over the selected data on which you need to select the option Space. From the drop-down list, select the Split text to columns option. Step 4: From the top Menu bar, click on the Data tab. Step 3: Select the entire column of data that you want to split. Step 2: Load up the data set of full names which you want to split on a spreadsheet in Google Sheets. Step 1: Open any web browser on your laptop and open Google Sheets. The below steps will make use of the split function to help you separate the first name and last name from a list of full names. We will use examples to explain how this feature can be useful.

Now that you have understood what are the different uses of the split text to columns function in Google Sheets, let us take a look at how you can use it. Steps to Use Split Text to Columns in Google Sheets You can get creative to use this function and let’s check out how to use it. Similarly, you can use the split function to extract username and domain name from a list of email IDs that you are working on. It also works when you want to separate letters and numeric values from a list of invoices. Let’s take a look at a few scenarios where splitting your data into two columns can be quite useful.įor example, on a spreadsheet with a huge list of names, you can split them by first name and second name in two different columns.

Apparently, with the help of it, you can avoid wasting time copying and pasting data into different columns. We”ll show you how to separate data into columns using the split text to columns function in Google Sheets.

How to add a text box in google sheets