Cutting Lenses - What Works

[qtrain23]

I think this one will work now

links in the first post

 

[marc2040]

Vertical text
Copy: =ARRAYFORMULA(CONCATENATE((MID( "Bartwolf"; ROW(INDIRECT("YY1:YY"&LEN( "My Data" ))); 1)&CHAR(10))))
Paste: Cell B1
Then see what happens

 

[qtrain23]

Vertical text
Copy: =ARRAYFORMULA(CONCATENATE((MID( "Bartwolf"; ROW(INDIRECT("YY1:YY"&LEN( "My Data" ))); 1)&CHAR(10))))
Paste: Cell B1
Then see what happens

formula contains an error?

 

[marc2040]

 

[qtrain23]

ah got it.

 

[qtrain23]

thanks for that. looks much better dont' you think?

 

[marc2040]

OK man, well done.
Plus:
Align Center
Align Bottom
Resize column to 40 or 50

 

[qtrain23]

OK man, well done.
Plus:
Align Center
Align Bottom
Resize column to 40 or 50

How about I just invite you to edit it aswell?

 

[marc2040]

mmmmhhh, my first google file. I think you can share:
Open G-Drive in your browser, go to your file, mark, more (drop-down), share, share, email address (my nick @ g mail dot com)

 

[qtrain23]

sent a link to you

mynick