If you want numbers (rather than text), then put this in B1:

=--LEFT(A1,SEARCH("/",A1)-1)

and this in C1:

=--RIGHT(A1,LEN(A1)-SEARCH("/",A1))

assuming your data is in A1. If you want text values then omit the --.
Then copy down to cover your data.

Hope this helps.

Pete


On Apr 21, 5:06*pm, 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