Opposite to CONCATENATE function

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

TRIM IF CELL CONTAINS ONE WORD, ABBREVIATE IF IT CONTAINS MULTIPLE WORDS 1
Concatenate Opposite? 3
Separating text in a cell 2
How specify number format of cell value in concatenate function? 1
Excel Concatenate with line breaks but ignore blank cells 3
Concatenate By Selection 2
Concatenate many cells 14
Calculate the function in a cell that is created with CONCATENATE 2

Back
Top