Find & replace 

Shortcut: Ctrl+H 

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: 

You can also select the following options: 

Automatic: replacements will be performed automatically.  If this option is not selected, then the 

program will display a dialog box before the old cell content is replaced with the new text. 

All columns: all columns will be searched through.  If this option is not selected, then the find & replace 

procedure will be limited to the current column (the column containing the cell pointer).  

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 menu 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. 

29