How to do Text-to-Columns in Google Spreadsheets


Text can live in many places and thanks to copy/paste, text can be easily moved around from application to application. However, when it comes to lists and easy organization, pasting can become a little complicated.

Pasting in Google Sheets can become especially difficult when you want to paste a list or text that you want to separate into different cells. The former solution to separating text was with a script, but Google announced this week that you can now easily convert text to columns in Sheets with new paste formatting options.

Watch the video demonstration above to learn more.

Get the best tips and tricks in your inbox daily