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?