How to display text using a research function

users
#1

Hello,

I have two columns A and B

Column A contains emails and column B is empty

I wish that each time in column A is detected certain words like 'trans',
'sped' ... can be directly displayed in column B on the same line the word
'transportation and Logistics'.

I don't know which function to use

Thanks in advance for your help

Regards

#2

in french :
CHERCHE("trans";A2)
give the position of "trans" in cell A2

Je la 13/06/2016 13:07, valcoteau skribis :

#3

valcoteau wrote:

> Hello,
>
> I have two columns A and B
>
> Column A contains emails and column B is empty
>
> I wish that each time in column A is detected certain words like 'trans',
> 'sped' ... can be directly displayed in column B on the same line the word
> 'transportation and Logistics'.
>
> I don't know which function to use
>
> Thanks in advance for your help
>
> Regards

Something like this (in B1 and copying down):

=IF(OR(ISNUMBER(SEARCH("trans";A1));ISNUMBER(SEARCH("sped";A1)));"Transportation and Logistics";"")

#4

Hello

Thanks a lot it's perfect

:slight_smile: