Filling the G-Apps: Vertical Text in Google Spreadsheet

By -
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))))

Comments

Post a Comment

Popular posts from this blog

Stay COVID Meeting Safe

By -
I've had a number of people asking me recently about using recently popularised Apps due to COVID-19 in personal situations. In my personal opinion, I would steer away from both Zoom and Houseparty in particular, use something that is tried and tested like Messenger , Hangouts , Facetime or WhatsApp and ensure they're up to date as the latter two have also had hacking issues in the past due to people not updating after identified security breaches. Both Apps are very popular at the moment and have had security and privacy concerns raised. Houseparty has been reviewed by security experts which have said: "it's probably safe". It has safe security options but it is up to the end-user to implement them correctly. Having said that if you read the fine print Houseparty uses your personal data and advertising as their income (nothing is free), there have been reports of users having their login details for Netflix and Spotify accounts compromised but these ar...
Read more

Cyber Security Awareness 002: Understanding PII (Personally Identifiable Information)

By -
Image
PII (Personally Identifiable Information) What is PII and what should I be aware of? What is PII? In terms of Cyber Security PII (Personally Identifiable Information) is any information associated with the target that could be used as potential leverage for an attack against that individual, an associate, or the company they work for as well as any clients and suppliers the business deals with.
Read more

COVID-19 Coronavirus v Technology Path

By -
It's surprising what can instill business remodeling and push for changes in technology or an increase in an uptake. COVID-19 has had an extreme impact in our daily routines and has pushed towards a working from home in ways that would have taken years to become the norm.  Don't get me wrong we've been on our way there in the past few years with the developments onto cloud and SAAS solutions; on-line tools, integrations and deliveries; ICQ to Skype to a plethora of communication solutions. In the company I work for/with I've had to roll out a solution we've has available in a SAAS group but never pushed on as it was a convenience solution in place of face-to-face meetings primarily used for FIFO (fly-in-fly-out) clients that might have a limited schedule to communicate and not be in a convenient location. However now that COVID-19 had reared its head into the workplace it obviously creates a risk factor for a traditional face-to-face meeting which is quite likely to...
Read more