Why would you need VBA? You could use standard Excel funcionality:
Go to Data = Text to Columns and define comma as your delimiter.

Joerg

wrote in message
oups.com...
Would anyone please help me write a VBA progam to do the following:
A cell (e.g. Cell(A1)) contains a string; alphet, 12.3, 23.4, 56.7
Break the string and put each of them in separate cells (e.g.
alphbet in Cell(B2), 12.3 in Cell(C2),
23.4 in Cell(D2), and 56.7 in Cell(E2)).
Thank you,