Find and Replace in Calc: Can I search for two numbers at the same time?

calc

asked 2018-04-09 10:55:48 +0100

Astralogic
3 ●7 ●9 ●11

Find and Replace in Calc: Can I search for two numbers at the same time in the find and replace dialog?

edit retag flag offensive close merge delete

add a comment

1 Answer

Sort by » oldest newest most voted

answered 2018-04-09 11:34:40 +0100

erAck

4518 ●29 ●51 https://erack.de/

You 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.

edit flag offensive delete link

Comments

Ah, 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?

Mike Kaganski ( 2018-04-09 11:40:10 +0100 )edit

add a comment

Question Tools

1 follower

Stats

Asked: 2018-04-09 10:55:48 +0100

Seen: 24 times

Last updated: Apr 09 '18

Find and Replace in Calc: Can I search for two numbers at the same time? edit

1 Answer

Comments

Question Tools

Stats

Related questions

Find and Replace in Calc: Can I search for two numbers at the same time?