Calc How to make Chunking the words?

[evx80]

Hi,

i am doing Crossword need to chunking the words into a single litter
Example>
Beautiful B, E, A, U, T, I, F, U, L,

each litter in column

---

Thanks

[schiavinatto]

See formula in image … and drag down

---

ATTENTION: If you would like to give more details to your question, use edit in question or add a comment below. Thank you.

If the answer met your need, please click on the ball to the left of the answer, to finish the question.

[evx80]

hello Gilberto Schiavinatto,
Thank you work perfectly.
=UPPER(MID($A$1,ROW()-0,1))

sorry I forget to mention how to do it horizontally?

[schiavinatto]

Switch row by column (considering the same situation)

=UPPER(MID($B$4;COLUMN()-2;1))

[evx80]

Nice many thanks

[schiavinatto]

If the answer met your need, please click on the ball to the left of the answer, to finish the question.