yogi_Split A String Into Its Constituent Characters And Sum Up The Numeric Digits Ignoring The Non-Numeric Characters

                                         Google Spreadsheet   Post  #1612
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?

this is a followup question to the one addressed in the following blog post:

yogi_Split A String Into Its Constituent Characters
http://yogi--anand-consulting.blogspot.com/2014/04/yogisplit-string-into-its-constituent.html

Follow up:
What about the SUM array thing for this method? For digits that is. Just sum them up and not print the parts one per row.
-------------------------------------------------------------------------------------------------------------------------------------------------

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

yogi_Compute Row By Row The Zodiac Sign Based On Person's BirthDay (actually just month and day)

                                         Google Spreadsheet   Post  #1608
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Apr-21-2014
post by Gillermo: (https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/eTn-lMBa09w)
Formula to determine the Zodiac sign?
Hi, I am trying to convert a date to the corresponding zodiac sign. But I can't get it to work.

The most sophisticated solution I've found is:
=LOOKUP(TEXT(B2;"md");{101;121;220;321;421;521;621;724;824;924;1024;1123;1222:"Capricorn";"Aquarius";"Pisces";"Aries";"Taurus";"Gemini";"Cancer";"Leo";"Virgo";"Libra";"Scorpio";"Sagittarius";"Capricorn"})

Source: http://www.mrexcel.com/forum/excel-questions/55815-formula-determine-zodiac-sign-3.html#post3641897

I am quite new to Google Sheet formulas and not really sure how to decipher the formula above. But I've validated some parts of it, and TEXT(B2;"md") works with my numbers and date format. To make it more complex, it seems like my language (Swedish) is forcing Google Docs to use semicolon instead of comma.
What is the stuff between the curly brackets? An array or a vector?
-----------------------------------------------------------------------------------------------------------------------------------------