Extract names formatted with specific colors at different positions

Asked

Viewed 53 times

-3

I have names and they have colors corresponding to the name of the color itself. I intend to extract these names referring to the colors I want. The problem is that they are in different positions, for example: how do I extract the characters in "Blue"??inserir a descrição da imagem aqui

excel

1 answer

1

EXT.TEXTO(A40;LOCALIZAR("AZUL";A40);4)

  • It was helpful. The problem is the spaces, in which case I would have to change the formula each time when it is a word I have in the middle of others and also have the amount of characters to be displayed, because for each specific space before the word I would have to change the formula. I have already made a conditional formula for their different spaces and characters. But it is very laborious and extensive, depending on the size of the word list

Browser other questions tagged excel

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