Does anyone have any suggestions on how to separate the value into different
cells?
For example, the text in cell A1 and A2 are shown below
1 CHEUNG KONG 929,000 83,737,500 3,933,462
354,652,820
196 HONGHUA GROUP 175,000 223,950 1,817,000
2,333,084

I would like to retrieve the last 4 values into
929,000 in AA1, 83,737,500 in AB1, 3,933,462 in AC1, 354,652,820 in AD1
175,000 in AA2, 223,950 in AB2, 1,817,000 in AC2, 2,333,084 in AD2

Does anyone have any suggestions on how to do it?
Thanks in advance for any suggestions
Eric