Finding and replacing text and formatting

From Apache OpenOffice Wiki
Jump to: navigation, search



Writer has a Find and Replace feature that automates the process of searching for text inside a document.

In addition to finding and replacing words and phrases, you can:

To display the Find & Replace dialog box, use the keyboard shortcut Control+F or select Edit > Find & Replace.

  1. Type the text you want to find in the Search for box.
  2. To replace the text with different text, type the new text in the Replace with box.
  3. You can select various options, such as matching the case, matching whole words only, or doing a search for similar words. (See below for some other choices.)
  4. When you have set up your search, click Find. To replace text, click Replace instead.
The Find & Replace dialog.
Tip.png If you click Find All, Writer selects all instances of the search text in the document. Similarly, if you click Replace All button, Writer will replace all matches.


Documentation caution.png Use Replace All with caution; otherwise, you may end up with some hilarious (and highly embarrassing) mistakes. A mistake with Replace All might require a manual, word-by-word search to fix.

Use wildcards (regular expressions)

Wildcards (also known as regular expressions) are combinations of characters that instruct OOo how to search for something. Regular expressions are very powerful but not very intuitive. They can save time and effort by combining multiple finds into one.

Table 1 shows a few of the regular expressions used by OOo.

Tip.png The online help describes many more regular expressions and their uses.


Documentation note.png To search for a character that is defined as a wildcard, type a backslash (\) before the character. For example, to find the text $5.00, you would search for \$5\.00.

To use wildcards and regular expressions when searching and replacing:

  1. On the Find & Replace dialog box, click More Options to see more choices. On this expanded dialog box, select the Regular expressions checkbox.
  2. Type the search text, including the wildcards, in the Search for box and the replacement text (if any) in the Replace with box. Not all regular expressions work as replacement characters; the line break (\n) is one that does work.
  3. Click Find, Find All, Replace, or Replace All (not recommended).
Expanded Find & Replace dialog.

Table 1. Examples of search wildcards (regular expressions)

To find Use this expression Examples and comments
Any single character . b.d finds bad, bud, bid, and bed.
Any string of characters .* b.*d finds bad, brand, and board.
One of the specified characters [xyz] b[iu]n finds bin and bun.
Any single character in this range [x-y] [r-t]eed finds reed, seed, and teed; ranges must be in alphabetically ascending order.
Any single character except the characters inside the brackets [^x] p[^a]st finds post and pest, but not past.
The beginning of a word \<start \<log finds logbook and logistics, but not catalog.
The end of a word end\> log\> finds catalog, but not logistics.
A paragraph marker $ Does not work as a replacement character. Use \n instead.
A line break \n Finds a line break that was inserted with Shift+Enter. When used as a replacement character, it inserts a paragraph marker.

Find and replace specific formatting

A very powerful use of Find & Replace takes advantage of the format option. For example, you might want to replace underlined words with italics.

On the Find & Replace dialog box (with More Options displayed):

  1. To search for text with specific formatting, enter the text in the Search for box. To search for specific formatting only, delete any text in the Search for box.
  2. Click Format to display the Text Format (Search) dialog box. The tabs on this dialog box are similar to those on the Paragraph format and Paragraph Style dialog boxes. Choose the formats you want to search for and then click OK. The names of selected formats appear under the Search for box. For example, you might search for all text in 14-point bold Helvetica.
  3. To replace text, enter the replacement text in the Replace with box.
    To search for specific text with specific formatting (for example, the word hello in bold), specify the formatting, put the text in the Search for box and leave the Replace with box blank.
    To remove specific character formatting, click Format, select the Font tab, then select the opposite format (for example, No Bold). The No Format button on the Find & Replace dialog box clears all previously selected formats.
  4. Click Find, Find All, Replace, or Replace All.
Tip.png Unless you plan to search for other text using those same attributes, click No Format to remove the attributes after completing your search. If you forget to do this, you may wonder why your next search fails to find words you know are in the document.


Find and replace paragraph styles

If you combine material from several sources, you may discover that lots of unwanted paragraph styles have suddenly shown up in your document. To quickly change all the paragraphs of one (unwanted) style to another (preferred) style:

  1. On the expanded Find & Replace dialog box, select Search for Styles. (If you have attributes specified, this checkbox is labeled Including Styles.) The Search for and Replace with boxes now contain a list of styles.
  2. Select the styles you want to search for and replace.
  3. Click Find, Find All, Replace, or Replace All.
Content on this page is licensed under the Creative Common Attribution 3.0 license (CC-BY).
Personal tools