Split Text to Columns in Google Sheets (separate first and last name)

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-text-to-columns-google-sheets/ You May Also like the following Google Sheets Tutorials: -- https://www.youtube.com/watch?v=o45dMvV4RjU -- https://www.youtube.com/watch?v=8DIKWsRYuGY -- https://www.youtube.com/watch?v=PhDMxUtemsQ -- https://www.youtube.com/watch?v=ZAdFaM-upNU Subscribe to this YouTube channel to get updates on Google Sheets Tips and Google Sheets Tutorials videos - https://www.youtube.com/c/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