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 $86$ D$23$

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

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

Calculate the average GNP in cell D$24$

$7(10)$ What is the average GNP for the data nrovided?