Find and Replace in PowerPivot

Find and Replace in PowerPivot

December 30, 2015

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



Please reload

Contact Me With Your Litigation Support Questions:

  • Twitter Long Shadow

© 2015 by Sean O'Shea . Proudly created with