My love for Google Sheets grows more every day.
Recently I had to split a list of names into first name and last name. I discovered that it’s *really* simple with Google Sheets. No complicated Excel formula to figure out… just a couple of mouse clicks and *presto*… you’re done.
- Open your Google Sheets file.
- Select the column you want to split.
- From the Data menu click on Split Text to Columns
- Choose the “separator” and hit enter.
Now simply download your file as a *.csv and it’s ready to import into your favorite software… like YouCanFollow.Me!
Wait… what? You don’t have an account?