Friday, May 9, 2014

yogi_Illustration For Orienting Text Vertically In Google Spreadsheet -- Formula Based Solution


                                         Google Spreadsheet   Post  #1628
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   May-09-2014


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

post by: Deb14 -- question by AlexJVar: (https://productforums.google.com/forum/#!mydiscussions/docs/KdyxPSBGjjI)

Man, this is Convoluted!!  How do I add to this post without "Replying" to someone else's post?  

I have tried using the suggested formula:

=ARRAYFORMULA(CONCATENATE((MID( "My Data"; ROW(INDIRECT("YY1:YY"&LEN( "My Data" ))); 1)&CHAR(10))))

And it does not work.  

The text I want to orient vertically is "ADP Websuites 1000 Direct".  I have tried: =ARRAYFORMULA(CONCATENATE((MID( "ADP Websuites 1000 Direct"; ROW(INDIRECT("YY1:YY"&LEN( "ADP Websuites 1000 Direct" ))); 1)&CHAR(10)))), and I have tried: =ARRAYFORMULA(CONCATENATE((MID( ADP Websuites 1000 Direct; ROW(INDIRECT("YY1:YY"&LEN( ADP Websuites 1000 Direct ))); 1)&CHAR(10)))), and all I get is the entire string of characters, all crammed into the cell in which I want it.  

Does anyone know how this works?  Thank you.  
-----------------------------------------------------------------------------------------------------------------------------
sorry you are having difficulty using formula based solution for orienting text vertically in Google spreadsheet -- I hope the following illustration helps