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:

Please Login or Register  to view this content.

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.