Spliting a cell

[israel]

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

 

[Gary''s Student]

Data > Text to Columns... > Delimited > and use /

 

[Jacob Skaria]

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

 

[Pete_UK]

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