How to transfer a specific number to another cell

[jumada06]

Sir,

I have this data from our hatchery unit and I need only the number of damaged eggs without the number of actual eggs delivered:

Breakages(%)
680/129600
1120/129600
1200/133200
1120/129600
680/129600
760/133200
920/259200
504/129600
416/129600

There are thousands of this info and I find it very inconvenient to copy manually the damaged eggs to another cell. I used the Left and Right formula but does not give me the result I want.

Your prompt assistance is highly appreciated.

Regards,
Dio

 

[dave3009]

This is the formula which I would use with only one addition: =LEFT(A1,FIND("/",A1)-1)*1 which will ensure that the return is a number. If there are cells which may not contain a "/" you could enhance it further with IFERROR(LEFT(A1,FIND("/",A1)-1)*1,"") to return a blank if the LEFT formula would have generated and error.

Regards


Miles

Yeah, those amendments might be OK, but the quickest and easiest method is still text to columns as suggested originally. It would negate converting a number returned as text to a number and assessing if there is an error, notwithstanding the dragging down thousands of rows.

 

[miless2111s]

True, the dragging down thing is easily solved with Control copy or ALT D etc but the formula works best if you're dropping the data in as raw data from somewhere else etc. It is good to learn something new as I didn't know about your method. Thanks

 

[Peter_SSs]

True, the dragging down thing is easily solved with ..

.. or double-click the Fill Handle if there are no gaps in the original data & your formula is in the next column.