Hi,

I have information in one column imported from another system. The
information is structured in one text string but each row includes a set of 4
different data strings diveded by a comma ",". Like this:
Red,house,door,20000
blue,cat,mouth,500
etc

I need a macro that look at all rows and dived the information in to 4
diffrent columns like this;

column A B C D
Red house door 20000
blue cat mouth 500

Grateful for any help in this issue.
Thanks!
Mats