Reputation
910
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
1 7 22
Newest
 Yearling
Impact
~51k people reached

May
6
comment Text to columns conversion in Google Spreadsheets
Nice... How do you call it without extending the UI. Can you add a quick example demonstrating usage?
Dec
16
comment Text to columns conversion in Google Spreadsheets
@espertus Looks like Google got rid of the script gallery in favor of their new add-ons thing. Just copy the code above into a script, close, then reopen the document and it should work.
Jul
7
awarded  Yearling
Mar
28
awarded  Famous Question
Jan
16
awarded  Nice Answer
Dec
9
awarded  Nice Question
Jul
7
awarded  Yearling
May
6
awarded  Popular Question
Feb
8
comment Text to columns conversion in Google Spreadsheets
@bobesponja Thanks for the heads-up. I know there's a bug with Google Scripts where event triggers from imported scripts don't register properly. To fix it, just add the onOpen trigger manually.
Feb
1
comment Text to columns conversion in Google Spreadsheets
@JacobJanTuinstra In your first solution try copying B2 to B3. The result cells contain continuation formulas, not raw data. The cells outputted from the script contain the actual raw data so they can be copied/moved without any issues. The intent of this question is to find an equivalent to Excel's 'Text to Columns' feature. Until, Google officially adds support the script is as close as it's going to get.
Feb
1
revised Text to columns conversion in Google Spreadsheets
deleted 1281 characters in body
Jan
31
comment Text to columns conversion in Google Spreadsheets
@JacobJanTuinstra Because the capability can be added via Google Apps Scripting. I ended up solving my own problem by writing a 'Text To Columns' script that can now be found in the Script Gallery. Googlegooru also posted a video tutorial demonstrating its usage here googlegooru.com/text-columns-google-spreadsheets.
Jan
31
accepted Text to columns conversion in Google Spreadsheets
Jan
3
awarded  Notable Question
Dec
14
awarded  Self-Learner
Dec
7
revised Text to columns conversion in Google Spreadsheets
added 85 characters in body
Dec
7
revised Text to columns conversion in Google Spreadsheets
added 85 characters in body
Nov
30
revised Text to columns conversion in Google Spreadsheets
added 106 characters in body
Nov
29
revised Text to columns conversion in Google Spreadsheets
added 229 characters in body
Sep
5
comment How can I avoid sites that scrape and republish others?
@Basilevs lol, I'm glad I could help.