function verticalText() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss.getActiveSheet();
var cell = sheet.getActiveCell();
var text = cell.getValue();
var formula = "=ARRAYFORMULA(CONCATENATE((MID(\""+text+"\";ROW(INDIRECT(\"YY1:YY\"&LEN(\""+text+"\")));1)&CHAR(10))))";
cell.setFormula(formula);
}
Be the first to comment
You can use [html][/html], [css][/css], [php][/php] and more to embed the code. Urls are automatically hyperlinked. Line breaks and paragraphs are automatically generated.