Maybe a combination of =search(), =find(), mid(), =left() and =right() would
work.

Or if your data is laid out nicely, you could use:
data|text to columns (xl2003 menu system)

If the data is delimited or fixed width, this method is very fast.

Aaron wrote:

Hi,

Is there a function opposite to concatenate that splits text in a cell?

Thanks

--

Dave Peterson