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++.


Contact Me With Your Litigation Support Questions:

seankevinoshea@hotmail.com

  • Twitter Long Shadow

© 2015 by Sean O'Shea . Proudly created with Wix.com