Combining 3 formulas into one

Hi there,

I'm trying to combine the 3 formulas below that I currently have in column F of the attached spreadsheet so that they all evaluate at the same time.

=VALUE(LEFT(C4,6))
=VALUE(MID(C6,3,10))
=VALUE(MID(C7,3,6))

Any help would be greatly appreciated.

Attachment 231528