A1 = 3/5.4

B1 =VALUE(TRIM(LEFT(SUBSTITUTE(A1,"/",REPT(" ",100)),10)))
C1 =VALUE(TRIM(RIGHT(SUBSTITUTE(A1,"/",REPT(" ",100)),10)))

If this post helps click Yes
---------------
Jacob Skaria


"israel" wrote:

Hi,

I'm looking to split a cell data into two separate cells.
Explain; 3/5.4 is the data in cell, it stands for qty.=3, size =5.4
now I have to split the qty which would be three in its own cell and 5.4 in
its own cell. This data is in 500 rows.

I appreciate your reply
Thank you
--
smile