Spliting a cell

  • Thread starter Thread starter israel
  • Start date Start date
I

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