tag:blogger.com,1999:blog-8807805591547673516.post6974103200550583452..comments2013-06-25T17:22:11.351-07:00Comments on Cloud Computing -- Google Docs Way: yogi_Writing Vertically In Google SpreadsheetYogi Anandnoreply@blogger.comBlogger9125tag:blogger.com,1999:blog-8807805591547673516.post-34290621196396374472013-04-10T12:52:43.983-07:002013-04-10T12:52:43.983-07:00Hi Robert:
You should be able to use formula acro...Hi Robert:<br /><br />You should be able to use formula across ... if it didn't work for you, chances are there is a mistake in the formula -- why don't you check your formula and let me know how it goes.<br /><br />Make It A Great One<br />Cheers!<br />Yogi<br />Cloud Computing -- Google Docs Way<br />yogi--anand-consulting.blogspot.comYogi Anandhttps://www.blogger.com/profile/10862524957172908621noreply@blogger.comtag:blogger.com,1999:blog-8807805591547673516.post-67854682153884322182013-04-10T08:33:38.334-07:002013-04-10T08:33:38.334-07:00Hi Yogi, ok, so i tried this vertical writing thin...Hi Yogi, ok, so i tried this vertical writing thing...i am using it for a timesheet and want to keep my guys hours on it...so obviously writing horizontally takes up a lot of room.<br /><br />However, i used your formula, then a few seconds later after everything looked great google docs went to save it and then it disappeared, showing up as "ERROR: Circular dependency detected"...but maybe this was only after I tried to copy and paste the formula so i could use it across an entire row...?Robert Martinhttps://www.blogger.com/profile/17671703808515294202noreply@blogger.comtag:blogger.com,1999:blog-8807805591547673516.post-18823547438032032872012-09-18T07:00:15.954-07:002012-09-18T07:00:15.954-07:00You Are Very Welcome Norman ... Now Let us Keep Go...You Are Very Welcome Norman ... Now Let us Keep Googling.<br /><br />Cheers!<br />Yogi<br />Cloud Computing -- Google Docs Way<br />yogi--anand-consulting.blogspot.comYogi Anandhttps://www.blogger.com/profile/10862524957172908621noreply@blogger.comtag:blogger.com,1999:blog-8807805591547673516.post-47358439259561330792012-09-17T23:22:43.699-07:002012-09-17T23:22:43.699-07:00Thanks Yogi, my big problem is solved by your post...Thanks Yogi, my big problem is solved by your post :)Nomanhttps://www.blogger.com/profile/10147957132007629897noreply@blogger.comtag:blogger.com,1999:blog-8807805591547673516.post-49529911513115574362012-09-06T12:47:54.807-07:002012-09-06T12:47:54.807-07:00That's really helpful. Thankns for posting!That's really helpful. Thankns for posting!Richard Wadehttps://www.blogger.com/profile/03244312293277003561noreply@blogger.comtag:blogger.com,1999:blog-8807805591547673516.post-28763721382963046442012-09-03T21:12:02.376-07:002012-09-03T21:12:02.376-07:00The formula in cell A1 looks at the TEXT in cell E...The formula in cell A1 looks at the TEXT in cell E1 and breaks it down into each individual character and then use of Char(10) rearranges each character in its own line thus the original TEXT in cell E1 is rearranged in vertical orientation in cell A1.<br /><br />I hope this helps.<br /><br />Cheers!<br />Yogi<br />Cloud Computing -- Google Docs Way<br />yogi--anand-consulting.blogspot.com<br /><br />Yogi Anandhttps://www.blogger.com/profile/10862524957172908621noreply@blogger.comtag:blogger.com,1999:blog-8807805591547673516.post-75313602696328084632012-09-03T19:12:09.954-07:002012-09-03T19:12:09.954-07:00I have not been able to deconstruct this formula. ...I have not been able to deconstruct this formula. Would you mind explaining it?Unknownhttps://www.blogger.com/profile/13016715008540299322noreply@blogger.comtag:blogger.com,1999:blog-8807805591547673516.post-47798962655718078292011-04-13T14:11:36.936-07:002011-04-13T14:11:36.936-07:00Hi Julie:
The formula is written in the cell in w...Hi Julie:<br /><br />The formula is written in the cell in which you want the vertical writing to appear ... so in the two examples in this post, the formula is written in cell A1 and the result in writing in the vertical orientation.<br /><br />I hope this helps.yogiahttps://www.blogger.com/profile/10862524957172908621noreply@blogger.comtag:blogger.com,1999:blog-8807805591547673516.post-66711649732231469722011-04-13T09:38:52.813-07:002011-04-13T09:38:52.813-07:00Where do you input the formula? I keep trying and ...Where do you input the formula? I keep trying and it doesnÂ´t seem to work.Juliehttps://www.blogger.com/profile/13768765114084692441noreply@blogger.com