Ask Your Question
0

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

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

Astralogic gravatar image

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

1 Answer

Sort by » oldest newest most voted
1

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

erAck gravatar image

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 more

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 gravatar imageMike Kaganski ( 2018-04-09 11:40:10 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

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

Seen: 24 times

Last updated: Apr 09 '18