Making 2 cells out of one

  • Thread starter Thread starter ×1
  • Start date Start date
×

×1

Hi Excel experts!
I would like to know how can divide the expression "<0.05" which is now in
one cell, into 2 seperate cells, the first with "<" and the second with
"0.05".
Thank you very much,
Elad
 
In the first cell

=LEFT(A1)

in the second


=RIGHT(A1,LEN(A1)-1)

the easiest is data>text to columns fixed width and click after >


--


Regards,


Peo Sjoblom
 
Thank you very much!
Elad

Peo Sjoblom said:
In the first cell

=LEFT(A1)

in the second


=RIGHT(A1,LEN(A1)-1)

the easiest is data>text to columns fixed width and click after >


--


Regards,


Peo Sjoblom
Click to expand...
 

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

Making one long colum out of many 18
Standard deviation calculation error... 7
Numeric Data Entry problem 2
Percentage problem in Excel 2003 1
compare for high with two or more cells and then flag. 1
Conditional coloring of columns in column chart 2
Data Entry Problem 3
Variable Data in Equations 1

Back
Top