How to Separately put comma separated values in adjacent cells

[en19ma]

Hi all,

kindly advise

i want to put all values either separated by Space or by commas and put all into adjacent cells in a single row...

for example:
ABCDE BUY 500 @ 92.5500, BRK = 27.75, CVT = 4.63, WHT = .00, FED = 4.44


Thanks.