STRINGS$-$ manipulating text

In the worksheet $4-$StringParsing you are given data that contains year, quarter and GNP$.$ This data is all contained in the first column.

You are to create formulas using string functions $($referred to in Excel as TEXT functions$)$ to isolate the year, quarter and GNP value into columns B$,$ C and D$.$

Specifically, enter these formulas into cells B$6$:D$23$

$5.(10)$ What was the formula you used to isolate the year? Enter it in the text box below.

Enter your formula here

$6.(10)$ What was the formula you used to isolate the quarter? Enter it in the text box below

Enter your formula here

Calculate the average GNP in cell D$24$

$7.(10)$ What is the average GNP for the data provided? Enter it in the text box below:

Enter your numeric answer here