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