splitting my cell
 

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

splitting my cell
 

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

splitting my cell
 

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

splitting my cell
 

Data/ Text to columns/ delimited, and specify your | character as the
delimiter.
--
David Biddulph

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

splitting my cell
 

=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

splitting my cell
 

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