Watch Video – How to Split Text to Columns in Google Sheets
You can use the Split Text to Columns in Google Sheets to quickly split the contents of a cell (or a range of cells).
Split Text to Columns feature comes in handy when you want quickly split the first name and the last name, or the user name and domain name from an email id, or the domain name from URLs.
In this tutorial, I will show you multiple examples on how to split text to columns in Google Sheets.
Below is a dataset with the names of some of my favorite superheroes:
Here are steps to split the full name into the first and last name:
That’s it! It will instantly split the names into the first name and the last name.
Suppose you have a dataset with emails as shown below:
Here are the steps to use Split Text to Columns to separate username and domain name:
As soon as you enter @, Google Sheets will instantly split the text into username and domain name.
Again, remember that this will overwrite on the original dataset. If you want to keep the original data set intact, create a copy and then use Split Text to Columns feature.
Suppose you have a dataset as shown below:
Note that there is a mix of URLs where some only have the root domain and some have links to a specific page/post.
Here are the steps to get the domain name from URLs using Split Text to Columns:
Note that as soon as you enter /, the URLs will spit and the domain name would be in column C.
Now if you’re wondering why column B is empty, it’s because there are two forward slashes after HTTP in the URLs. Each forward slash is treated as an individual separator.
Also, note that this technique works when you have the domain names in the same format. For example, if you have one with HTTP and one without it, then it may give you the domain names in different columns.
You May Also Like the following Google Sheets Tutorials:
How to Use OR Function in Google Sheets (with Examples)
How to Use IMPORTRANGE Function in Google Sheets (with Examples)
How to Use IMPORTDATA function in Google Sheets
Calculate the Number of Days Between Two Dates in Google Sheets
Using IFS Function in Google Sheets to Test Multiple Conditions