Opposite to CONCATENATE function

[Guest]

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?

 

[Guest]

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

 

[Carim]

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