Need help creating formula to separate line into different cells.

[rudyr123]

Okay, I'm trying to make my work as easy as possible. I wanted to know if it was to take a string in excel and break it into different cells?

For example lets say cell A1 has Colors=Black/Khaki;Forest/Khaki;Khaki/Black;Navy/Khaki;Orange/Navy;Red/Black;Royal/White;White/Black

How would I go about making cell A2 have Colors=Black/Khaki, A3 Colors=Forest/Khaki, A4 Khaki/Black etc. The string in A1 has semi colons so we could use that as a separator.

=??("Colors=",A2,?)

Is this possible? Thank you in advance for the help.

Rudy

[ragavan.sridar1]

Did you tried Text to columns function?