Depending upon the elements.................

DataText to ColumnsDelimited byOther.

Enter the pipe and Next to see what you get.

If dealing with dates or numbers with a preceding 0 you should go to Next and
Format Data Column.

Select Date or Text

If looks OK hit Finish.


Gord Dibben MS Excel MVP


On Wed, 26 Sep 2007 16:06:00 -0700, Baxter
wrote:

I have a field with two data elements, separated by a | (pipe symbol). I
would like to populate the 1st half into one cell, and the 2nd half into
another cell. This is the opposite of the Excel function "Concatenate".