Partial data extraction from a cell

[linesite]

I'm trying to extract the four digit year from a cell containing the following text:

08-01-2014 00:13

This is an example of a single cell of many rows of data all in the same column. I need a formula that will extract the year into the empty cell next to it on the same row. The data will always look like this and there is a single space separating the year and the time.

 

[Momentman]

Like this maybe

Excel 2010
	A	B
1	08/01/2014 00:13	2014
Sheet15

Cell Formulas
Range	Formula
B1	=TEXT(A1,"yyyy")

 

[linesite]

I need it to be a real number. I will concatenate data with day and month.

 

[bschwartz]

Wrap it in a VALUE argument then. =VALUE(TEXT(A1,"yyyy"))

 

[Momentman]

Like this maybe
Excel 2010

	A	B
1	08/01/2014 00:13	2014

<colgroup><col style="width: 25pxpx"><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet15​

Worksheet Formulas Cell Formula B1 =TEXT(A1,"yyyy") <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

Real number? like
1*Text(A1,"yyyy")

 

[linesite]

Thank you kindly sir it works. I appreciate your help!