Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenMon, 09 Apr 2018 11:40:10 +0200Find and Replace in Calc: Can I search for two numbers at the same time?https://ask.libreoffice.org/en/question/151798/find-and-replace-in-calc-can-i-search-for-two-numbers-at-the-same-time/ Find and Replace in Calc: Can I search for two numbers at the same time in the find and replace dialog?Mon, 09 Apr 2018 10:55:48 +0200https://ask.libreoffice.org/en/question/151798/find-and-replace-in-calc-can-i-search-for-two-numbers-at-the-same-time/Answer by Mike Kaganski for <p>Find and Replace in Calc: Can I search for two numbers at the same time in the find and replace dialog?</p>
https://ask.libreoffice.org/en/question/151798/find-and-replace-in-calc-can-i-search-for-two-numbers-at-the-same-time/?answer=151801#post-id-151801No, you can't.Mon, 09 Apr 2018 11:18:09 +0200https://ask.libreoffice.org/en/question/151798/find-and-replace-in-calc-can-i-search-for-two-numbers-at-the-same-time/?answer=151801#post-id-151801Answer by erAck for <p>Find and Replace in Calc: Can I search for two numbers at the same time in the find and replace dialog?</p>
https://ask.libreoffice.org/en/question/151798/find-and-replace-in-calc-can-i-search-for-two-numbers-at-the-same-time/?answer=151803#post-id-151803You can. Use regular expressions. For example, to search for the two numbers 123 or 456 the Find expression would be `123|456` and under *Other options* check *Regular expressions*.Mon, 09 Apr 2018 11:34:40 +0200https://ask.libreoffice.org/en/question/151798/find-and-replace-in-calc-can-i-search-for-two-numbers-at-the-same-time/?answer=151803#post-id-151803Comment by Mike Kaganski for <p>You can. Use regular expressions. For example, to search for the two numbers 123 or 456 the Find expression would be <code>123|456</code> and under <em>Other options</em> check <em>Regular expressions</em>.</p>
https://ask.libreoffice.org/en/question/151798/find-and-replace-in-calc-can-i-search-for-two-numbers-at-the-same-time/?comment=151805#post-id-151805Ah, you are right - I misinterpreted the question as asking for search in two different cells at once! What was that which I used for thinking at that moment I wonder?Mon, 09 Apr 2018 11:40:10 +0200https://ask.libreoffice.org/en/question/151798/find-and-replace-in-calc-can-i-search-for-two-numbers-at-the-same-time/?comment=151805#post-id-151805