Frequently asked questions - Calc
TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate
How to search for several terms at once
Context
You want to search for more than one text string (example: 12, 25) at once in a selected range using the "Find & Replace..." dialog in
▸ menu.The | character is used in regular expressions to search on what is entered before or after the sign.
But you can't just search for 12|25 because the text (or numbers) could equally occur in combinations like 123, 255, 312, etc.
Solution
Add the expressions ^ and $ to indicate that the search term should only occur at the start and the end of the "paragraph" respectively: