Spreadsheet: 73132d1273775921-excel-2007-extract-text-from-string-boxscores-help-needed
Sheet: Raw Data

1 Cher The Colosseum at Caesars Palace |  | Las Vegas, Nev. | April 10-25, 2010 | $4,910,221 |  | 35,343 / 40,168 | $250, $175, $140, $95 | Concerts West/AEG Live
2 Andre Rieu Gelredome |  | Arnhem, Netherlands | Dec. 19-20, 2009 | $3,408,360 |  | 34,500 / 39,600 | $114.81, $78.93 | Andre Rieu Productions
3 Los Tres: [NAME], [NAME], [NAME] Center |  | Anaheim, Calif. | April 9-10, 2010 | $2,345,645 |  | 24,189 / 26,753 | $404, $43.50 | Live Nation/Alvarez & Garner
4 [NAME], [NAME], Gloriana Staples Center |  | Los Angeles, Calif. | April 15-16, 2010 | $1,736,197 |  | 27,518 / 27,518 | $69.50, $59.50, $49.50, $25 | The Messina Group/AEG Live
5 Andre Rieu Forest National |  | Brussels, Belgium | Dec. 10-12, 2009 | $1,566,460 |  | 16,500 / 17,400 | $108.95, $50.06 | Andre Rieu Productions
6 Andre Rieu Lanxess Arena |  | Koln, Germany | Jan. 1-2, 2010 | $1,563,860 |  | 10,808 / 17,658 | $107.74, $64.65 | [NAME]
7 George Strait, [NAME], [NAME] BOK Center |  | Tulsa, Okla. | Feb. 20, 2010 | $1,551,967 |  | 18,098 / 18,098 | $89.50, $79.50 | Varnell Enterprises
8 George Strait, [NAME], [NAME] U.S. Airways Center |  | Phoenix, Ariz. | Feb. 5, 2010 | $1,509,703 |  | 17,568 / 17,568 | $89.50, $79.50 | Varnell Enterprises
9 [NAME], [NAME], [NAME] |  | Omaha, Neb. | 2010-04-08 00:00:00 | $1,500,319 |  | 17,347 / 17,347 | $89.50, $79.50 | Varnell Enterprises
10 [NAME], [NAME], Gloriana Pepsi Center |  | Denver, Colo. | April 6-7, 2010 | $1,497,135 |  | 25,991 / 25,991 | $59.50, $49.50, $25 | The Messina Group/AEG Live
11 George Strait, [NAME], [NAME] Verizon Arena |  | North Little Rock, Ark. | 2010-03-06 00:00:00 | $1,324,706 |  | 15,497 / 16,650 | $89.50, $79.50 | Varnell Enterprises
12 George Strait, [NAME], [NAME] Greensboro Coliseum |  | Greensboro, N.C. | Jan. 23, 2010 | $1,308,725 |  | 15,500 / 17,000 | $89.50, $79.50 | Varnell Enterprises
13 [NAME], [NAME], [NAME] |  | Knoxville, Tenn. | 2010-04-02 00:00:00 | $1,306,756 |  | 16,290 / 17,500 | $89.50, $79.50 | Varnell Enterprises
14 George Strait, [NAME], [NAME] INTRUST Bank Arena |  | Wichita, Kan. | Feb. 19, 2010 | $1,259,197 |  | 14,652 / 14,652 | $89.50, $79.50 | Varnell Enterprises
15 AC/DC, Rival Sons MGM Grand Garden |  | Las Vegas, Nev. | 2010-04-09 00:00:00 | $1,251,156 |  | 13,609 / 13,609 | $93.98 | Live Nation/Andrew Hewitt Co.
16 George Strait, [NAME], [NAME] Tacoma Dome |  | Tacoma, Wash. | 2010-03-27 00:00:00 | $1,245,370 |  | 14,790 / 18,000 | $89.50, $79.50 | Varnell Enterprises
17 [NAME] [NAME] Fargo Arena |  | Des Moines, Iowa | 2010-04-16 00:00:00 | $1,102,920 |  | 14,250 / 14,250 | $139, $39 | Goldenvoice/AEG Live
18 Andre Rieu O2 World |  | Berlin, Germany | Jan. 23, 2010 | $1,091,830 |  | 11,300 / 11,689 | $105.94, $63.57 | [NAME]
19 AC/DC, Black Frog Bradley Center |  | Milwaukee, Wis. | 2010-04-15 00:00:00 | $1,064,357 |  | 13,288 / 15,011 | $89.50, $48 | Live Nation/Jam Productions
20 Andre Rieu Ethias Arena |  | Hasselt, Belgium | Dec. 22-23, 2009 | $1,055,070 |  | 12,500 / 14,000 | $101.71, $65.90 | Andre Rieu Productions
21 [NAME], [NAME] United Center |  | Chicago, Ill. | 2010-04-10 00:00:00 | $924,484 |  | 14,583 / 14,583 | $77, $34 | Live Nation
22 Spandau Ballet, Tears For Fears, [NAME] |  | Melbourne, Australia | 2010-04-21 00:00:00 | $890,792 |  | 8,483 / 9,245 | $119.30, $78.13 | Dainty Consolidated Entertainment
23 Nickelback, Shinedown, Sick Puppies Atlantic City Boardwalk Hall |  | Atlantic City, N.J. | 2010-04-03 00:00:00 | $858,814 |  | 11,804 / 11,804 | $89.50, $69.50, $35 | Caesars Atlantic City
24 Nickelback, [NAME], Shinedown, Sick Puppies Verizon Center |  | Washington, D.C. | 2010-04-13 00:00:00 | $787,330 |  | 12,448 / 13,362 | $77.50, $42.50 | Live Nation
25 [NAME], [NAME], Gloriana Sprint Center |  | Kansas City, Mo. | 2010-04-02 00:00:00 | $761,110 |  | 13,781 / 13,781 | $59.50, $49.50, $25 | The Messina Group/AEG Live
26 Santana The Joint, Hard Rock Hotel |  | Las Vegas, Nev. | April 21-25, 2010 | $730,315 |  | 8,053 / 10,837 | $151, $51 | AEG Live
27 [NAME], [NAME], Gloriana HP Pavilion |  | San Jose, Calif. | 2010-04-11 00:00:00 | $716,726 |  | 12,744 / 12,744 | $59.50, $49.50, $25 | The Messina Group/AEG Live
28 Muse, Silversun Pickups Oracle Arena |  | Oakland, Calif. | 2010-04-14 00:00:00 | $678,912 |  | 15,805 / 15,805 | $56.75, $33.25 | Live Nation/Another Planet Entertainment
29 [NAME], [NAME], Gloriana Ford Center |  | Oklahoma City, Okla. | 2010-03-31 00:00:00 | $675,184 |  | 11,795 / 11,795 | $59.50, $49.50, $25 | The Messina Group/AEG Live
30 Los Tres: [NAME], [NAME], [NAME] Amphitheatre |  | [NAME], Calif. | 2010-04-11 00:00:00 | $655,683 |  | 10,749 / 19,491 | $300, $14 | Live Nation/Alvarez & Garner
31 [NAME], [NAME], Gloriana Save Mart Center |  | Fresno, Calif. | 2010-04-10 00:00:00 | $649,488 |  | 11,706 / 11,706 | $59.50, $49.50, $25 | The Messina Group/AEG Live
32 Andre Rieu Hanns-Martin-Schleyer-Halle |  | Stuttgart, Germany | Feb. 20, 2010 | $636,127 |  | 8,311 / 8,844 | $101.41, $60.85 | [NAME]
33 Andre Rieu Hallenstadion |  | Zurich, Switzerland | Feb. 26-27, 2010 | $631,922 |  | 10,063 / 20,280 | $110.69, $55.34 | [NAME]
34 [NAME], [NAME], Gloriana INTRUST Bank Arena |  | Wichita, Kan. | 2010-04-01 00:00:00 | $610,801 |  | 11,228 / 11,228 | $59.50, $49.50, $25 | The Messina Group/AEG Live
35 Andre Rieu O2 World |  | Hamburg, Germany | Jan. 9, 2010 | $564,579 |  | 6,643 / 7,807 | $107.50, $64.50 | [NAME]
36 Andre Rieu Olympiahalle |  | Munich, Germany | Feb. 22, 2010 | $528,353 |  | 6,554 / 9,457 | $102.07, $61.24 | [NAME]
37 Andre Rieu Westfalenhalle |  | Dortmund, Germany | Jan. 22, 2010 | $499,099 |  | 5,407 / 8,577 | $105.67, $63.40 | [NAME]
38 [NAME], [NAME], Lost Trailers New Orleans Arena |  | New Orleans, La. | 2010-04-10 00:00:00 | $477,898 |  | 11,272 / 12,467 | $67.75, $37.75 | Live Nation/in-house
39 Andre Rieu Messehalle |  | Erfurt, Germany | Jan. 15, 2010 | $463,145 |  | 5,334 / 5,334 | $108.84, $65.30 | [NAME]
40 Andre Rieu TUI Arena |  | Hannover, Germany | Jan. 16, 2010 | $460,289 |  | 5,084 / 9,326 | $108.12, $64.87 | [NAME]
41 Andre Rieu Zenith |  | Nantes, France | Dec. 1, 2009 | $458,559 |  | 5,739 / 6,341 | $92.87, $67.32 | Andre Rieu Productions
42 Andre Rieu Geneva Arena |  | Geneva, Switzerland | Nov. 18, 2009 | $455,197 |  | 4,464 / 4,595 | $108.66, $79.03 | Andre Rieu Productions
43 Andre Rieu Galaxie |  | Amneville, France | Nov. 20, 2009 | $452,480 |  | 5,472 / 5,472 | $104.33, $66.77 | Andre Rieu Productions
44 [NAME], [NAME], [NAME] |  | Melbourne, Australia | 2010-04-19 00:00:00 | $446,593 |  | 5,814 / 5,995 | $76.81 | Chugg Entertainment