Excel Project: Parsing Data Go to the student download page at http://www.pearsonhighered.com/romney and download the file labeled “P6-4CustomerData.xlsx”. For this problem, assume that your supervisor gave you this file and said that it contains information about customers. The file has several fields merged together and your supervisor wants you to parse them into separate fields.

REQUIRED Separate the fields as instructed in parts a and b below.

a) Parse the data on the “Data – Simplified” sheet. Put your solution on the

“Simplified Solution” sheet. The image below shows the solution for the first three rows. Your solution should separate the information using only formulas. Leave the formulas in your solution file for grading. As a hint, you can solve this problem using a combination of the LEFT, RIGHT, MID, FIND, and VALUE formulas.

b) Parse the data on the “Data – Advanced” sheet. Put your solution on the “Advanced Solution” sheet. The image below shows the solution for the first three rows. Your solution should separate the information using only formulas. Leave the formulas in your solution file for grading. As a hint, you can solve this problem using a combination of the LEFT, RIGHT, MID, FIND, TRIM, SUBSTITUTE, REPT, LEN, and VALUE formulas.