splitting my cell

  • Thread starter Thread starter rodchar
  • Start date Start date
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
 
=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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

assigning id's 2
summing only certain rows 2
copy rows down 2
a sorting dilemma 2
comparing 2 sheets 3
excel to xml export help 1
VBA Multiple Line handling with Split() 1
comparing 2 columns 2

Back
Top