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:

seankevinoshea@hotmail.com

  • Twitter Long Shadow

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