Opposite to CONCATENATE function

J

John

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?
 
D

Dave F

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
 
C

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
 
Top