What is replace?

The function replace helps you quickly replace numbers , characters or symbols that are the same in a range of cells with another set of numbers, characters or symbols

You can replace a common prefix, suffix or any character across cells by using Range.

In the below example we want to replace xls with txt.

1. To do this first highlight the column.

2. Click on Edit, Replace.

3. Enter in Find What what you want to replace. In our example we want to replace xls therefore enter xls.
Enter in Replace with: txt, this is what we want to see as the result.

4. Click on replace all. The result is shown below. As you can see, xls is now replaced with txt.