Hello Chandan.jh,
Welcome to the Forum!
You gave only one example of the data you want to separate. You did not say whether the output would vertical (rows) or Horizontal (columns). This macro will correctly parse any text string according to your rules and output the results either vertically (the default) or horizontally to the cell of your choice.
The OutputDirection is optional. You can use one of two Excel built-in constants: xlByRows or xlByColumns. If you do not specify one of the constants then the default is by rows.
Here is an example of using the macro. The Text is on "Sheet2" cell "A1". The output is going to "Sheet1" cell "B1". All parsed data will start in "B1" and move across to "C1", "D1", etc.
Bookmarks