Ask Your Question

Find 'Whole Words Only' - Where is this option?

asked 2021-02-09 13:22:20 +0200

phx27 gravatar image

updated 2021-02-09 14:00:13 +0200

v7.0.4.2 Calc MacOS I need to find the word 'Door' in my document, not 'Doors'. I have the Find & Replace dialogue box open, there is no option for 'Whole Words Only'. It's not in 'Other Options' either. Where is this option?

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2021-02-09 13:34:23 +0200

Opaque gravatar image

updated 2021-02-09 16:07:11 +0200


image description


Other options [x] Regular expression and
Find \bDoor\b (where \b means word boundary)


  • Deleted the user profile stuff, since the confusion is caused by incorrect tagging (OP tagged writer while being interested in calc)
  • There is no Whole words only-option in Calc. You need to use Alternative above to find any cells containing word Door somewhere in the cell. If you need cells containing Door only you could use Find ^Door$

Hope that helps.

edit flag offensive delete link more


I used your alternative, thanks. It would be even easier to have the 'Find Whole Words' option in Calc.

phx27 gravatar imagephx27 ( 2021-02-09 14:01:57 +0200 )edit

@Opaque, should not the penultimate sentence in your answer read:

"...containing Dooronly you could use Find^Door$"

BigRAl gravatar imageBigRAl ( 2021-02-09 15:53:38 +0200 )edit

@BigRAl - Sure you are right, sorry for the typo and thanks for the hint. Corrected.

Opaque gravatar imageOpaque ( 2021-02-09 16:06:53 +0200 )edit

answered 2021-02-09 13:40:31 +0200

phx27 gravatar image

updated 2021-02-09 13:48:19 +0200

Where? image description

edit flag offensive delete link more


This is not Writer and you tagged your question writer. You need to ask a correct question and you might get a correct answer. Your screenshot shows Find&Replace in Calc. If you want that in Calc, use Alternative in my answer below, which finds all cells having word Door somewhere in the text. If you want find cells, which contain only Word Door and nothing else, use Find: ^Door$

Opaque gravatar imageOpaque ( 2021-02-09 13:45:23 +0200 )edit

In calc using macros you should be able to find single words without any problems.

If in calc then you use a range of data with filters for each column it definitely solves the problem

torreone gravatar imagetorreone ( 2021-02-09 15:00:10 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2021-02-09 13:22:20 +0200

Seen: 41 times

Last updated: Feb 09