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";"")
--
Piet van Oostrum <[email protected]>
WWW: http://pietvanoostrum.com/
PGP key: [8DAE142BE17999C4]
--
To unsubscribe e-mail to: [email protected]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
