help with Mid, left, right, search

[rmooretrans]

Cant seem to get the formula right for extracting which numbers I need out. ex.
a1 contains- w, 90-88 or L, 90-88
trying to extract first number if "w" and second number if "L"

can get the second without out the if "W" or "L" by using
=RIGHT(a1,LEN(a1)-SEARCH("-",a1,1)) gives me "88". getting the first number without the "w," or "L," is a different story using
=LEFT(a1,LEN(a1)-SEARCH(" ",a1,1)) gives me "w, 90"

and when I want one or the another based on the "W" or "L", well I'm lost.
Need some pointers in the right direction. Thx.

 

[barry houdini]

Assuming first character can only be "L" or "W" try

=IF(LEFT(A1)="L",REPLACE(A1,1,FIND("-",A1),"")+0,MID(A1,4,FIND("-",A1)-4)+0)

 

[rmooretrans]

Yu'da man. Thx.

 

[Peter_SSs]

I don't suppose those numbers are always 2 digits so that you could use the following?

=MID(A1,4+3*(LEFT(A1)="L"),2)+0