Tuesday, February 1, 2011

yogi_Writing Vertically In Google Spreadsheet

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                            www.energyefficientbuild.com

UPDATED Feb-07-2011 (added solution using REGEXREPLACE)




Writing in vertical orientation via a command or menu is not supported in Google Spreadsheet; one can however accomplish this using a formula.

So let us say we want to write vertically in cell A1 the text housed in cell E1
then formula in cell A1 ...
=ArrayFormula(concatenate(mid(E1,row(indirect("z1:z"&len(E1))),1)&char(10)))

or using REGEXREPLACE

=regexreplace(A1,".","$1"&char(10))





Now let us write vertically in cell A1 the text housed in cells C1 and D1
then formula in cell E1 is ... = C1&" "&D1
and formula in cell A1 ...
=ArrayFormula(concatenate(mid(E1,row(indirect("z1:z"&len(E1))),1)&char(10)))

or using REGEXREPLACE

=regexreplace(C1&" "&D1,"(.)","$1"&char(10))