I have the following data for HS & College and I'd like to extract only the HS Year as shown below:
<tbody>
</tbody>
Is there a formula to achieve this? Noting that the original entries in the column HS & College can have a space or not after the first colon.
Any help would be appreciated as I'm brain fried at the moment.
Thanks!
Maria
HS & College | HS Year (Result I want) |
HS Year: 2001/Univ Year: 2006 | 2001 |
HS Year:1997/Univ Year:2005 | 1997 |
<tbody>
</tbody>
Is there a formula to achieve this? Noting that the original entries in the column HS & College can have a space or not after the first colon.
Any help would be appreciated as I'm brain fried at the moment.
Thanks!
Maria