Hi, I am new to this forum, and VERY new to the excel formula.
I am having trouble at work to retrieve partial number from cells.
Here is the source data in Column A:

A
S$100.09 @ 0.587682
USD 8859 @ 0.593472
EURO5,332.32@1.6633

(sometimes there's no space, sometimes there's no comma, but "@" will always be there to separate the amount and rate)

Below are what I would like to achieve in Column B to D .

B
SGD
USD
EUR

C
100.09
8859
5332.32

D
0.587682
0.593472
1.6633

It would really be appreciated if someone could help me to sort this out.
I tried to google but I really have no clue with formulae like SUMPRODUCT, INDEX, LEN, etc...
Really thanks!