Calc Find and Replace [Fax:]

Can someone explain why Calc won’t replace “Fax:” It will replace “Fax” and it will also replace “:” so why won’t it replace them together?

For me it works without any problems.

Version: (x64) / LibreOffice Community
Build ID: 9c0871452b3918c1019dde9bfac75448afc4b57f
CPU threads: 8; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win
Locale: de-DE (de_DE); UI: de-DE
Calc: CL

Perhaps you have a space somewhere in the cell? Can you upload a small sample file that shows the problem?

1 Like

Thanks for replying. I went thru and did it all before I posted. It also wouldn’t find the parenthesis for (area code) in phone numbers, so I just kept changing the area code. I was hoping to learn something for future use.

Please complete your question.
The help on this page is mainly provided by users like you.

Your question and the corresponding description should be as detailed as possible.
Please remember that no one can look over your shoulder when you ask your question and describe it.

In order to be able to help you, we need to know your operating system and the LibreOffice version (four-digit, e.g.
Please also state the file type in which you have saved your file.

All important information about your initial question should be present in the initial question box, otherwise edit and complete it., to do it.

Please do not use answers (solutions) or comments for this.

If you have already fulfilled some of these requirements, so much the better. Thanks.

Upload a reduced and anonymized file here so that someone can examine it.

Here you can find the further References for this page.

Thank you very much for your assistance.

Is regular expressions checked? Then parenthesus form capture groups unless quoted and a colon may be used like :digits:

Only as set expression, e.g. [:digits:] and a single trailing : doesn’t do anything special.

I wonder if Fax: and () were in the formatting of the cells? Attached sheet will not find those nor the leading 0.
Fax&ParenthesesNoFindReplace.ods (17.2 KB)

1 Like