Opposite to CONCATENATE function
 

Hello,

The CONCATENATE function is fantastic for joining text from 3 cells to one.
But is there a function that will seperate 1 cell's information to 3 or more
cells?

Opposite to CONCATENATE function
 

Tools--Data--text to column

Select your delimeter (probably a space) and you're good to go.

As for a de-concatenate function, no, there isn't one built in. But I
imagine you could create a UDF if you didn't want to use the
Tools--Data--text to column solution.

Dave
--
Brevity is the soul of wit.


"John" wrote:

Hello,

The CONCATENATE function is fantastic for joining text from 3 cells to one.
But is there a function that will seperate 1 cell's information to 3 or more
cells?

Opposite to CONCATENATE function
 

Hi John,


There are several possibilites depending on what your problem is ...
But generally speaking, Left() Mid() and Right() are the functions used
to split a cell...

HTH
Cheers
Carim