Need to remove some contents of a cell.

In a nutshell I need the following accomplished:

Cell A1: MK-ISO-L-63P2155-3-R6321-A -- Cell B1: MK-ISO-L-63P2155-3-A

I need to remove the 'R6321' from the tag, only problem is, the number of characters of the tags are not alway's the same nor is the 'R6321' it changes too (there are roughly 1500 variations of this alpha numeric).

One thing that DOES stay the same is the format with the dashes. It always goes: MK-ISO-L-WWW-X-YYYYY-Z.

The number of 'W's changes, the number of 'X's changes and the number of Y's change, I think a formula that looks at dashes to remove the Y's would work...but cannot figure out how to do it.

PLEASE HELP...THE BOSS IS LEANING ON ME PRETTY GOOD TO GET THIS TASK DONE!

Here is an example of what cell's I have now, and what I need to see.

PLEASE HELP

Thank you in advance for your time.

If a VBA solution is OK, try this UDF:

Function RemoveToken(sInp As String, iToken As Long, Optional sSep As String = "-") As String
    Dim astr() As String
    Dim i As Long
    Dim n As Long
    
    astr = Split(sInp, sSep)
    If UBound(astr) < iToken - 1 Then
        RemoveToken = sInp
    Else
        For i = iToken - 1 To UBound(astr) - 1
            astr(i) = astr(i + 1)
        Next i
        ReDim Preserve astr(UBound(astr) - 1)
        RemoveToken = Join(astr, sSep)
    End If
End Function

Usage for you would be

=RemoveToken(A2, 6)

or
=LEFT(A1,FIND("/",SUBSTITUTE(A1,"-","/",5))-1)&RIGHT(A1,2)

Much simpler, Martin.

Worked like a charm. Thanks guy's.