Reputation
977
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
1 9 22
Impact
~61k people reached

Sep
8
comment Text to columns conversion in Google Spreadsheets
@Rubén So much for stability. I checked earlier and was under the impression that scripting was gone altogether. Turns out, they only killed the script gallery. I'm going with the answer you recommended because it's the simplest scriptable solution. Thanks for the feedback.
Sep
8
accepted Text to columns conversion in Google Spreadsheets
Sep
8
comment Text to columns conversion in Google Spreadsheets
@Rubén Done. Thanks for pointing that out.
Sep
8
revised Text to columns conversion in Google Spreadsheets
deleted 194 characters in body
Sep
8
awarded  Good Question
Sep
8
revised Text to columns conversion in Google Spreadsheets
added 145 characters in body
Sep
7
awarded  Notable Question
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
3
awarded  Notable Question