How to Make Use of Split Text to Columns in Google Sheets – Guide
Splitting text into columns can be used in Google Sheets to split the content of a cell (or a range of cells) very quickly. O feature Splitting text into columns is very useful when you want to quickly split first and last name, or username and domain name from email id, or domain name from URLs. Here are several examples of how to Divide text into columns in Google Sheets. Soon you will know exactly how to split cells in Google Sheets like a pro.
Steps for Using Column Text Splitting in Google Sheets
Now that you understand the different uses of the split text into columns function in Google Sheets, let’s take a look at How to use it. We will use examples to explain how this feature it might be useful. The following steps will make use of the split function to help you separate the first and last name from a list of full names. Step 1: Open any web browser on your laptop and open Google Sheets. Step 2: Upload up the full name dataset that you want to split into a spreadsheet in Google Sheets. Step 3: Select any column of data you want to split. Step 4: From the top menu bar, click on the Data tab. From the drop-down list, select the Split text into columns option. Step 5: A Separator dialog will appear over the selected data, in which you need to select the Space option. Let’s say you have a comma-separated list of names. For example, Lord, Kelvin. You will need to select the Comma option in the Separator dialog box. In addition, you can also leave the Auto Detect option in the Separator dialog box. Step 6: As soon as you click on Space button, you will notice the full names being separated as first and last names. After that, you will have two separate lists of names in Google Sheets.
Final note
I hope you like the guide How to Make Use of Split Text to Columns in Google Sheets. In case if you have any query regards this article you may ask us. Also, please share your love by sharing this article with your friends.
