Find and Replace in PowerPivot


You cannot run a standard find and replace in PowerPivot, so use a SUBSTITUTE formula instead. See this example where I am inserting a pipe in front of a named string.

=SUBSTITUTE([F1]," String:","|String:")

This will work in a minute or two on data sets that are even too large to import into text editors like NotePad++.