Hi Leo

Have noted your update, many thanks once again.


--
George



*Leo Heuser* has posted this message:

Hi George

You're welcome and thanks for the feedback :-)

Should the day come, this formula can be used
regardless of the number of digits. The number
of spaces between the two results don't matter.

=IF(VALUE(LEFT(G7,FIND(" ",G7)))
VALUE(MID(G7,FIND(" ",G7),1000)),"Win",
IF(VALUE(LEFT(G7,FIND(" ",G7)))<
VALUE(MID(G7,FIND(" ",G7),1000)),"Lose","Draw")

Entered as one line.

LeoH


"George Gee" skrev i en meddelelse
...
Hi Leo

Many thanks for that, it works fine.
It would be a rare day indeed for a score of more than 9 in English
league football!

George