Find and Replace dialog

You can use "Find and Replace" dialog to find a string and then replace it with a new string. Before replace of the string you should find it by pressing "Find next" button.

The search starts from the current cell. If the string is found then a cell with the founded string is highlighted. Now you can replace it by pressing "Replace" button. Replace works only with the current cell.

Or you can use "Replace All" button to find all cells that contain the string and replace it with a new string in one action.

In "Replace with" edit line you can use placeholders.

To show "Find and replace" dialog you can use:

• keyboard shortcut Ctrl+H,
• or menu command "Edit -> Replace".

In Find what you can also use advanced regular expressions (ARE). You can see their full description here.

The Replace with text may contain back references \number which will be replaced with the value of the corresponding subexpression in the pattern match. \0 corresponds to the entire match and & is a synonym for it. Backslash may be used to quote itself or & character.