EXCEL. "Right" function how to set an automatic size for separate cells that exceeds the number of defined characters

Asked

Viewed 252 times

-1

I used the right function in cell "L33" but when I went to click and drag the values defined in the first cell, cell "L34" displayed not only the word 'technologies' but half the word 'software' and then the word 'technologies''.

How do I display only the word 'technologies' in cell "L34"??

In case I wanted to click and drag without having to worry about words that exceed the defined sizes.

inserir a descrição da imagem aqui

excel

1 answer

1


The last word is being found incorrectly.

Two forms that can be used to find the last word:

  • =DIREITA(H1;NÚM.CARACT(H1)-PROCURAR(" ";H1))

The problem with this function is that it only works for two words, it will return everything after the first spacing.

  • =ARRUMAR(DIREITA(SUBSTITUIR(ARRUMAR(H1);" ";REPT(" ";100));100))

This function returns the last word.

The concatenation of última palavra + " " + valor na coluna G is being performed in the right way:

=CONCATENAR(ARRUMAR(DIREITA(SUBSTITUIR(ARRUMAR(H1);" ";REPT(" ";100));100));" ";G1)

  • I just could not concatenate the numbering of the "G33", I tried: =TIDY(RIGHT PLACE(TIDY(H33);" ";REPT(" ";100));100);CONCATENATE(LEFT(H33;SEARCH(" ";H33)-1);" ";G33). But it obviously didn’t work out

  • 1

    It worked! just a correction there in the "concatenate" that got the 'R''

Browser other questions tagged excel

You are not signed in. Login or sign up in order to post.