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".

Make sure the column adjacent to the right is empty, if not insert a new
column to the right
select the column you want to split and do datatext to columns, select
delimited, click next and in the other box put the pipe character then click
finish. Make sure it does what you want before you save the workbook


--


Regards,


Peo Sjoblom





"Baxter" wrote in message
...
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".

Try this:

Select the single-column range of values

From the Excel Main Menu:
<data<text-to-columns.....Check: Delimited......Click [Next]
In the "other" box....Type the pipe symbol....Click [Finish]

Does that help?
Post back if you have more questions.
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)

"Baxter" wrote in message
...
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".

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".