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