Name change of dynamic data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have dynamic data from a pivot table that reads like this:

"Sum of xxxxxxx"

What formula do I use to convert all of these to "xxxxxxx"?

xxxxxx will change continually, but Sum of is always the same.
 
One guess is you want to strip the term: Sum of
out of the phrase: "Sum of xxxxxxx"
leaving only: "xxxxxxx"

If that's the case,
try in say B1: =SUBSTITUTE(A1,"Sum of ","")
where A1 contains: "Sum of xxxxxxx"
 
Back
Top