With the Replace Text feature you can search for a particular text in the Sheet Name or Sheet Title columns of the main data grid in order to be replaced with new text.

From the Home Tab of the Ribbon click the Replace Text button as shown below.

DM Remove Replace Text Button

On the Sheet Information – Replace Text dialog box enter the ‘Text’ to Find and then the new Replacement Text as per below example.  Use the tickboxes to replace text in the Sheet Name Column, Sheet Title Column or both.

DM Remove Replace Text dialog

Append New Line: if enabled will add a carriage return at the end of the replacement text

Category: