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


--
nsv
------------------------------------------------------------------------
nsv's Profile: http://www.excelforum.com/member.php...o&userid=26500
View this thread: http://www.excelforum.com/showthread...hreadid=515265