I have a spreadsheet with two numbers in the same cell, like this...

A1: $1.24(1.5)
A3: $2.35(1.6)
A5: $0.32(1.1)

I need to be able to divide the first number by the number that's in parentheses throughout the whole document. The parenthesis is right next to the first numbers without any space in between. Can this be done?

Thanks