In the first cell

=LEFT(A1)

in the second


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

the easiest is datatext to columns fixed width and click after


--


Regards,


Peo Sjoblom



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