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.