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]

Hi

Have you tries Text-To-Columns? Data | Text to Columns | Delimited -> Next | Other (insert / forward slash) -> Finish

Result before and after would look like this

Excel 2007
	A	B	C
1	Breakages(%)	Breakages(%) - After	After
2	680/129600	680	129600
3	1120/129600	1120	129600
4	1200/133200	1200	133200
5	1120/129600	1120	129600
6	680/129600	680	129600
7	760/133200	760	133200
8	920/259200	920	259200
9	504/129600	504	129600
10	416/129600	416	129600
Sheet4

Regards

Dave

 

[miless2111s]

When you say that you've tried left / right and it didn't work - in what way did it fail?

 

[jumada06]

When you say that you've tried left / right and it didn't work - in what way did it fail?

As you are aware the number of damaged eggs is not consistent in number upon delivery. So if I put =LEFT(A1,3) it will give only the first three digits.

Regards,
Dio

 

[jumada06]

Nope! I'll try for I haven't done the text to column formula yet.

Thank you,
Dio

 

[jumada06]

Hi,

Can you show or provide me the formula please.

Regards,
Dio

 

[dave3009]

It sounds like text to columns would be easier but if you must have a formula then =LEFT(A2,FIND("/",A2)-1)

 

[jumada06]

It sounds like text to columns would be easier but if you must have a formula then =LEFT(A2,FIND("/",A2)-1)

Thank you Dave. I'll apply it now and hope it works perfectly.

Dio

 

[Peter_SSs]

Nope! I'll try for I haven't done the text to column formula yet.

Thank you,
Dio

Text to Columns is not a formula, it's a quite quick manual process. In a copy of your workbook, try this.

1. Select the column of data by clicking its heading label.
2. On the Data ribbon tab click Text to Columns -> Delimited -> Next -> Type a / in the 'Other' box -> Finish

 

[miless2111s]

It sounds like text to columns would be easier but if you must have a formula then =LEFT(A2,FIND("/",A2)-1)

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