Sunday, 19 October 2014

Filling the G-Apps: Vertical Text in Google Spreadsheet

Vertical text in Google Drive is not something that exists yet however you can do within it's standard formatting however you can produce the same effect using a calculation where "LABEL" is the text you want displayed vertically:

  • =ARRAYFORMULA(CONCATENATE((MID( "LABEL", ROW(INDIRECT("YY1:YY"&LEN( "LABEL" ))), 1)&CHAR(10))))