Ok, this is gonna come off as really complicated, but really all i need to do
is to take what is outputted by this formula...

=IF('Shop Order Info'!B164="","",IF(COUNTIF('Shop Order
Info'!$B$2:B164,'Shop Order Info'!B164)1,"",'Shop Order Info'!B164))

Which outputs "SS-4-DATPM-4-2007" and remove the "-2007" from what the
formula returns. The reason i'm asking is because a formula taking the
output of this formula is adding an xtra "-2007". I cannot remove the second
formula's "-2007" because it's being used for a "Match( )" and removing it
causes the second formula to fail and therefore not outputting correctly.

(I can do it by removing it from the second formula, it just means I'd have
to manually redirect the formula to the right cell every time we changed the
order or added new data. Which is a real pain... __<''')

I want to find a way to have it remove the "-2007" from the first formula
w/o changing the data from the Shop Order Info sheet.

I figure I'm asking for the near impossible, but wth... I figured I'd try.