=LEFT(A1,FIND("|",A1)-1)
=RIGHT(A1,LEN(A1)-FIND("|",A1))

You can simplify the formulae if you know the number of characters either
side of the | character.
--
David Biddulph

"rodchar" wrote in message
...
that worked great thanks, by the way, is there a formula that can do the
same
thing?

"Max" wrote:

Try Data Text to Columns Delimited (type the separator*: |)
*Press Shift + Backslash key
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:16,200 Files:354 Subscribers:53
xdemechanik
---
"rodchar" wrote:
hey all
i have a cell like the following:
1|2

can someone please show me how to put the 1 and the 2 in 2 separate
columns?

thanks,
rodchar