Skip to main content
Mail a PDF copy of this page to:
(Your email address will not be added to a mailing list)
Show menu

Find & replace

Next selectFind & replace
Shortcut:Ctrl H


Locates a specified text and replaces it.

The Find & replace procedure can be used to replace certain values in the spreadsheet with another value, or clear the cells containing these values. The value to be located and to be replaced is entered in the Find field of the dialog box. The new value is entered in the Replace with field:

Find and replace


You do not have to enter any text in the Replace with input field. In this case, the cells containing the find text, will be cleared.

Refer to the Find command for some explanation concerning the search wildcards * and ?, and the way MedCalc performs text comparison and treats the search specification.

Remember that searching always starts from the current cell pointer position. So when you want to search an entire column, you must put the cell pointer in the top cell of this column.

See also