Re: [libreoffice-users] How to display text using a research function

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 <piet@vanoostrum.org>
WWW: http://pietvanoostrum.com/
PGP key: [8DAE142BE17999C4]


-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
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