Name change of dynamic data

[Al Allen]

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.

 

[Max]

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"