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
December 3, 2012 3:55 pm

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

Martin Hawksey
Guest
December 3, 2012 4:01 pm

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
January 24, 2013 12:52 am

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
June 6, 2013 9:18 pm

Great script! Help me a very lot!

Kyle Udemy
Guest
Kyle Udemy
September 11, 2013 1:39 am

Good stuff!

Tammy
Guest
Tammy
September 19, 2013 2:44 pm

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
February 7, 2014 4:23 pm

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

kathy
Guest
kathy
April 10, 2015 5:28 pm

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
April 18, 2015 8:44 pm

Works great! Thank you very much!

kojak edwards
Guest
kojak edwards
January 17, 2016 9:26 pm

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
Loading Facebook Comments ...