Function MID, Search

[g1terra]

I am trying to create a formula that will search a string that looks like this every time (see below). The issue is the TIME PERIOD: changes, could change to Quarter to date, Period to date etc.. So in other words I need the name of the word after when it says Timeperiod:

Any help is greatly appreciated!!


(Calculation: NPS or Average) & (Question Group: ALL METRICS) & (Benchmark: All Restaurants) & (Timeperiod: Trailing 6 Weeks) & (Reporting Date: Response Date)

[Fluff13]

What's wrong with the solutions you were given in your other thread, that you never replied to?

[alansidman]

Administrative Note:

Welcome to the forum.

Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

Please see Forum Rule #5 about thread duplication.

I am closing this thread, but you may continue here in the original thread: