Thursday, April 24, 2014

yogi_Split A String Into Its Constituent Characters


                                         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