Replacing a cell value with a new value

Select Edit > Replace.

In the Find field, type the text or number to be replaced.

In the Replace With field, type the text or number to replace the search value entered in the Find field.

Check the Replace All box to replace all instances of the value in the Find field.

Unchecking the Replace All box only replaces the first instance of the search value.


Legal Notice | Contact Certara
© Certara USA, Inc. All rights reserved.