Ask Your Question
0

Calc How to make Chunking the words?

asked 2019-05-13 16:58:04 +0100

evx80 gravatar image

updated 2019-05-13 17:25:01 +0100

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

image description


Thanks

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2019-05-13 17:45:05 +0100

See formula in image ... and drag down

image description


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 Descrição da imagem to the left of the answer, to finish the question.

edit flag offensive delete link more

Comments

hello Gilberto Schiavinatto, Thank you work perfectly.
=UPPER(MID($A$1,ROW()-0,1))
sorry I forget to mention how to do it horizontally?

evx80 gravatar imageevx80 ( 2019-05-13 18:13:51 +0100 )edit

Switch row by column (considering the same situation)

=UPPER(MID($B$4;COLUMN()-2;1))
Schiavinatto gravatar imageSchiavinatto ( 2019-05-13 18:31:17 +0100 )edit

Nice many thanks

evx80 gravatar imageevx80 ( 2019-05-13 19:41:48 +0100 )edit

If the answer met your need, please click on the ball Descrição da imagem to the left of the answer, to finish the question.

Schiavinatto gravatar imageSchiavinatto ( 2019-05-13 19:44:17 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2019-05-13 16:58:04 +0100

Seen: 34 times

Last updated: May 13