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

-1

I used the right function in cell "L33" but when I clicked and drag the values defined in the first cell, cell "L34" displayed not only the word 'technologies' but rather the word 'software' and in followed by 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.

    
asked by anonymous 10.10.2018 / 20:42

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 works only 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.

Concatenation of última palavra + " " + valor na coluna G is being performed in the correct way:

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

    
11.10.2018 / 16:39