Search
Find and Replace in PowerPivot
- Sean O'Shea
- Dec 30, 2015
- 1 min read
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++.
Recent Posts
See AllHow is data generated by aiR utilized by Relativity? Relativity has published a white paper addressing its AI security policies assuring...