Column with semicolon-separated values

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

Hi NSV,

With the data selected, try:

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


---
Regards,
Norman



"nsv" <[email protected]> wrote in message
news:[email protected]...
>
> 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