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

Hi NSV,

With the data selected, try:

Data | Text to Columns | Delimited | select the semicolon delimiter |
....


---
Regards,
Norman



"nsv" wrote in message
...

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

NSV,

From the menus Use 'Data' - 'Text to Columns'. Selected 'Delimited', hit
Next. In 'Delimiters uncheck whatever is checked, check 'Other' and type semi
colon in (preview now shows what you want) & hit Finish.

Regards,

Chris.

--
Chris Marlow
MCSD.NET, Microsoft Office XP Master


"nsv" wrote:


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

Oops, that was a bit embarassing. So simple and I couldn't find it
myself, but then - I've never noticed this function before...
Thanks a lot!!

NSV


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