I have a col with a number of semicolon separated values, just as if I had imported a complete .csv file directly into this one single col witout using the delimiter facility. A typical value is 13;K18;Novem4;Alfa;

Now I want to separate the values out into the neighbouring cols, just as if I had imported a .csv file delimiting it in the proces.
If above typical value were in cell A1, then B1 would contain "13", C1 would contain "K18", D1 would contain "Novem4" and E1 would contain the value "Alfa"

Is this possible without having to isolate the col, save it as a text file, import it again, etc..?


NSV