Split Text to Columns in Google Sheets (separate first and last name)
Article Link: https://spreadsheetpoint.com/separate...
Split Text to Columns in Google Sheets is a feature that comes in handy when you want quickly split the first name and the last name, or the user name and the domain name from email id, or the domain name from URLs.
00:00 Split Text to Columns Intro
00:10 Separate First and Last Name
01:31 Separate Username from Email Address
02:41 Separate domain name from the URL
In this tutorial, I will show you multiple examples on how to split text to columns in Google Sheets.
To use the Split Text to Columns options in Google Sheets, go to the Data tab and select 'Split Text to Columns'.
Here are important points to note while using Split Text to Columns in Google Sheets:
-- It overwrites the original data set. If you want to keep the original dataset intact, create a copy of the data set and use Split Text to Column on that data set.
-- It would give you static result. This means, that your data would not update in case you update the original dataset.
-- Every space character is considered as a different separator.
Read More: https://productivityspot.com/split-te...
You May Also like the following Google Sheets Tutorials:
-- • How to Add a Drop Down List in Google...
-- • How to Quickly Merge Cells in Google ...
-- • How to Freeze Rows and Columns in Goo...
-- • How to Insert an Image in a Cell in G...
Subscribe to this YouTube channel to get updates on Google Sheets Tips and Google Sheets Tutorials videos - / spreadsheetpoint
This channel is meant for people who want to learn about Google Sheets and be more productive in their day to day life. It covers a range of Google Sheets topics such as useful Google Sheets features, Google Sheets functions, Google Sheets formulas, Pivot table, Google Apps Script,.Shortcuts, Google Sheets Charting, Data Analysis, etc. Please subscribe to this channel and never miss a new video on Google Spreadsheets
You can also find a lot of useful resources on Google Sheets here: https://spreadsheetpoint.com/
#GoogleSheets #GoogleSheetsTips #Spreadsheet