With 1|2 in A1

B1 =Left(A1)

C1 =Right(A1)


Gord Dibben MS Excel MVP


On Tue, 22 Jul 2008 06:11:00 -0700, rodchar
wrote:

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