Formula Building.

[Spraggs]

Good Evening,
I have one column with a list of approx. 4000 machine tags.

Example.... 1234-ABC-DEF-GHI-AB123

The label can be anything from four digits to twentyfour digits (including "-")
The constant within the labelling are:
Dependant on label length there is always a "-" at the 5th, 9th, 13th , & 17th position.

So... assume the above machine tag is in cell A2, in cell B2 I want a formula that will give me a result 1234-ABC-DEF-GHI

Hence I want the formula to always remove the last "-" and anything after it.

Thanks Jase

 

[Jonmo1]

Thanks Jonmo, perfect.

Glad to help, thanks for the feedback.