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 <p...@vanoostrum.org> WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- To unsubscribe e-mail to: users+unsubscr...@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