Formula to extract values in cell before and after a /

[rob51852]

Hi guys

I have a spreadsheet with various cells in column A that contain data in the following format:

181/2 (18.3)

Are there some formulas that will copy the number before the / and the number immediately after (ignoring the number in brackets)?

I would like to copy the number before the / into column G and the number after the / into column H.

Thanks

 

[rob51852]

Brilliant guys. Thanks. You've saved me a lot of time

 

[Peter_SSs]

Brilliant guys. Thanks. You've saved me a lot of time

Glad you got a successful outcome.