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
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
Re: [libreoffice-users] How to display text using a research function
in french :
CHERCHE("trans";A2)
give the position of "trans" in cell A2
Je la 13/06/2016 13:07, valcoteau skribis :
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 -- View this
message in context:
http://nabble.documentfoundation.org/How-to-display-text-using-a-research-function-tp4186030.html
Sent from the Users mailing list archive at Nabble.com.
--
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
[libreoffice-users] How to display text using a research function
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 -- View this message in context: http://nabble.documentfoundation.org/How-to-display-text-using-a-research-function-tp4186030.html Sent from the Users mailing list archive at Nabble.com. -- 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
