Concatenate Opposite?

[kat]

Is there a function that will do the opposite of
concatenate? I need to parse a text cell into several
cells based based on semicolons.

Example:

12345 Main Street; Suite 123; Anywhere

Into three seperate cells.

Thanks in advance!

 

[JulieD]

Hi Kat

check out data / text to columns
use delimited

Let us kown how you go

Cheers
JulieD

 

[NH]

after selecting the coulm containg the address on the menu select data>text
to column
select delimited and then select ;
this will make your single list in separate columns

 

[kat]

Thanks!!! You are lifesavers!!!

-----Original Message-----
after selecting the coulm containg the address on the menu select data>text
to column
select delimited and then select ;
this will make your single list in separate columns



.