remove and separate

[chemmiah]

Hello all,

I am copying sports scores from the internet and the scores come in as 89-78 in one cell. I want a macro where it will take the data extract the first number in the next cell in the same row and extracts the second number into the third cell please see attached excel sheet.

[abduljaleel.mca]

use the attached macro

[chemmiah]

Abduljaleel.mca

Could you edit the macro so that it goes straight across? When I typed want 1st number here, i meant starting at the top, not where i put the text.

Sorry for the confusion.

Thanks.

[chemmiah]

Anyone can help. Thanx.

[Leith Ross]

Hello chemmiah,

You can formulas to separate the data into the cells and drag the formulas down.

Cell E1:

=LEFT($D1,SEARCH("-",$D1,1)-1)

Cell F1:

=RIGHT($D1,LEN($D1)-SEARCH("-",$D1,1))

[jindon]

No macro/formula

[Data] - [Text to Columns]

[chemmiah]

This works except it returns it as text and not a number. I want to take the numbers and use them in subsequent equations and i get errors because it treats the result as a text.

The macro above returns it as a number but the problem is it returns it in the wrong spot.

[Leith Ross]

Hello chemmiah,

If you are referring back to the formulas, here is the update to return numbers and not text.

Cell E1:

=VALUE(LEFT($D1,SEARCH("-",$D1,1)-1))

Cell F1:

=VALUE(RIGHT($D1,LEN($D1)-SEARCH("-",$D1,1)))

[chemmiah]

Thank you this totally worked.

[Leith Ross]

Hello chemmiah,

You're welcome.