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.

Shares

UP NEXT: How to Add a Hyperlink to a Google Sheet

Leave a Reply

10 Comments on "How to do Text-to-Columns in Google Spreadsheets"

Notify of
avatar
Sort by:   newest | oldest | most voted
Bob O
Guest
Bob O

Thanks for the helpful video. This saves me from exporting to Excel.

Martin Hawksey
Guest

You can also do this using the SPLIT formula http://support.google.com/drive/bin/answer.py?hl=en&answer=155358 e.g. in cell B1 I could enter =SPLIT(A1, ” “)

Bob Ferretti
Guest

Excellent quick tutorial and the script is great. It really is one of the annoying things I kept having to open Excel for. Thank you!

Marcos Gomes
Guest

Great script! Help me a very lot!

Kyle Udemy
Guest
Kyle Udemy

Good stuff!

Tammy
Guest
Tammy

Thanks for this great tip!! How do I make this script available for any of my open spreadsheet files? It seems to only be available for the one spreadsheet where I created it.

Mike McKenna
Guest
Mike McKenna

Great video. Thanks for posting. Quick question: where does the script reside? I don’t see it in my Google Drive.

kathy
Guest
kathy

this is the best. Took me 5 minutes to setup and now I have a one-button solution to a task I do all the time.

Bob B
Guest
Bob B

Works great! Thank you very much!

kojak edwards
Guest
kojak edwards

What a disappointment. When I clicked on the .txt file, it was empty. When I looked up Google Script Apps, it was nowhere to be found.

The only winner in all of this is Google Gooru. They get to sell my email address. I guess I can expect a boatload of spam/advertising.

Yea!!!

wpDiscuz