Formula to mirror only specific characters from another cell.

Cell #1: 07/23/2012 - 09:08

Cell #2: Formula to only show 07 (Character 2 of Cell #1)
Cell #3: Formula to show only 2012 (Characters 7-10 of Cell #1)

You can use MID function to get a fixed number of characters from another cell, so with data in A1 you can get the first 2 characters with

=MID(A1,1,2)

and characters 7 to 10 with

=MID(A1,7,4)

it's also possible to use LEFT function for the first one........