Question $2$: Using text functions extrac the City and state into column B$,$ the players name into column $C,$ his age into column $D,$ and his salary into column $E.$

$**$ Salary needs to be displayed as currency with $0$ decimal places$**$

Description

NAME: Sean Burnett POS: RP AGE: $30$ WT: $200$ BORN: Dunedin, FL SALARY: $2350000$

NAME: Tyler Clippard POS: RP AGE: $27$ WT: $200$ BORN: Lexington, KY SALARY: $1650000$

NAME: Ross Detwiler POS: SP AGE: $26$ WT: $174$ BORN: St$.$ Louis, MO SALARY: $485000$

NAME: Christian Garcia POS: RP AGE: $27$ WT: $215$ BORN: Miami, FL SALARY: N$/$A

NAME: Gio Gonzalez POS: SP AGE: $27$ WT: $205$ BORN: Hialeah, FL SALARY: $3335000$

NAME: Mike Gonzalez POS: RP AGE: $34$ WT: $215$ BORN: Robstown, TX SALARY: N$/$A

NAME: Ryan Mattheus POS: RP AGE: $28$ WT: $215$ BORN: Sacramento, CA SALARY: $481000$

$5$ NAME: Craig Stammen POS: RP AGE: $28$ WT: $200$ BORN: Coldwater, OH SALARY: $485000$

$6$ NAME: Drew Storen POS: RP AGE: $25$ WT: $180$ BORN: Indianapolis, IN SALARY: $498750$

NAME: Jordan Zimmermann POS: SP AGE: $26$ WT: $218$ BORN: Auburndale, WI SALARY: $2300000$