Google Spreadsheet Post #1611
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Apr-24-2014
post by Gillermo: (https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/b4zmtDKeIe8)
Divide string to rows?
How do I divide a string in a cell to multiple cells?
Example:
String in a single cell = GOOGLE
Result (each new line is a new row and cell):
G
O
G
L
E
My guess is that it is accomplishable with ArrayFormula, MID and LEN but I can't make it work.
------------------------------------------------------------------------------------------------------------------------------------
following is a solution using ARRAYFORMULA, MID. and LEN functions
No comments:
Post a Comment