Menu:
Replace
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. The result is shown below. As you can see, xls is now replaced with txt.
