Making 2 cells out of one

×

×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
 
P

Peo Sjoblom

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
 
×

×1

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