extracting data without using delimiter

hi guys i thought i had this wrapped but sadly not

in cell d2 i have 9-6
in cell aa2 i need the 9 and
in cell ab2 i need the 6

i previously used text to columns and a delimiter of -

however as i update this spreadsheet daily i wouldlike it to be done by formula instead
ie tomorrowcell d2 might be 10-7

thanks in advance

In AA2
=TRIM(LEFT(D2, SEARCH("-",D2)-1))+0
In AB2
=TRIM(MID(D2, SEARCH("-",D2)+1, 10))+0
How's that?

If you just want the values and not necessarily wanting the numbers to not be text:
This will extract the number left of the -

Formula:

Please Login or Register  to view this content.

This will extract the number right of the -

Formula:

Please Login or Register  to view this content.

If you want the values to be numbers and not text, add *1 to each formula and format as GENERAL or NUMBER

Formula:

Please Login or Register  to view this content.

and

Formula:

Please Login or Register  to view this content.