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

Data Text to Columns... Delimited and use /
--
Gary''s Student - gsnu200847


"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

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

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