Google/Docs

From Omnia
Revision as of 05:49, 26 November 2014 by Kenneth (talk | contribs) (Created page with "== Google Docs == == Text Rotation == =ARRAYFORMULA(CONCATENATE((MID( "Text to become vertical"; ROW(INDIRECT("YY1:YY"&LEN( "Text to become vertical" ))); 1)&CHAR(10)))) ...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

Google Docs

Text Rotation

=ARRAYFORMULA(CONCATENATE((MID( "Text to become vertical"; ROW(INDIRECT("YY1:YY"&LEN( "Text to become vertical" ))); 1)&CHAR(10))))
= regexreplace( "Text", "(.)", "$1"&char(10) )

If a cell is narrow, then here is a quick and dirty approach. Type the word into the spreadsheet cell with a space between each later.

References: