troubleshooting Question

Complex Formula - Excel 2010

Avatar of Mehawitchi
Mehawitchi asked on
Microsoft Excel
7 Comments2 Solutions352 ViewsLast Modified:
TV-Ratings-Sample.xlsxHello experts,

I need to build text formulas for extracting specific parts from the following text, which relates to TV rating:

CBS: "60 Minutes" (14.55 million viewers, 9.1/15 households)
NBC: "Dateline" (8.35 million, 5.4/9)
ABC: "America's Funniest Home Videos" (7.6 million, 4.3/7)
FOX: "Bob's Burgers" rerun (1.9 million, 1.2/2)/"The Cleveland Show" (2.7 million, 1.6/2)

For example, statement #1 should be broken-down into:
CBS
60 Minutes
14.55
9.1
15

statement #2 should be broken-down into:
NBC
Dateline
8.35
4.5
9

In othere words, I need 5 formulas for extracting: Channel name (NBC) , Show Title (Dateline), Audience size (8.35), audience rating (4.5) and Household number (9).

The good news is that the format of statements is standard, as you can see from the above four samples.

Therefore, I would really appreciate your help in creating complex Excel formulas for extracting the above bits.

Thank you,
Hani
ASKER CERTIFIED SOLUTION
Saqib Husain
Engineer

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 2 Answers and 7 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 7 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros