View Categories

How do I use the REPLACE or SUBSTITUTE functions to replace text in Excel?

< 1 min read

1. To replace text in Excel, select the cell with the content you would like to replace and open the Replace or Substitute command
2. Identify what you would like to replace – for example, a specific character or set of characters
3. Specify the string or text you want to use as a replacement
4. Click Replace or Substitute to execute the command
5. Verify the result and save your worksheet.

Powered by BetterDocs