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