splitting my cell

R

rodchar

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
 
R

rodchar

that worked great thanks, by the way, is there a formula that can do the same
thing?
 
D

David Biddulph

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

David Biddulph

=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.
 
Top