![]() ![]() If for some reason you’d rather use a formula for G oogle Spreadsheet vertical text in a cell you can use the REGEXREPLACE formula like so: = REGEXREPLACE ( A1, "(.)", "$1" & CHAR ( 10 ) )Īll you have to do is change A1 to the cell you’d like to source the text from.Īlternatively, you can type the text in quotation marks instead of a cell reference like so: = REGEXREPLACE ("Different Text", "(.)", "$1" & CHAR ( 10 ) ) Using a Formula to Make Text Vertical in Google Sheets Hover the mouse on the Text Rotation option. ![]() Click on the Format option in the menu. ![]() You can also use the Format options in the menu to rotate text in Google Sheets. How to Write Vertically in Google Sheets Using the Format Options You can make G oogle Sheets vertical text or specify the angle at which you want to text rotation done.
0 Comments
Leave a Reply. |