Find and Replace

In Tolls in Tabular ribbon there is a Find and Replace option.

1. In the Find what box, type the text or numbers you want to find.
2. In the Replace with box, enter the text or numbers you want to use to replace the search text.

If you want to replace all possible text or numbers in the sheet select Replace All
If you want to replace only some cells you need to select them at first and then click Replace Selected

Match case – Check this if you want to search for case-sensitive data.
Match entire cell contents – Check this if you want to search for cells that contain only the characters that you typed in the Find what box.

Note This can be applied to any unlocked cells within a QRT.