String manipulation with exceptions

In this If statement you can test for your exceptions and then NOT trim your SKU accordingly.

        If Pos > 0 Then
          If SKU <> "AU9929-ASST" then
            TrimSKU = Left(Text, Pos - 1)
          End If
        Else

You will need to add a check for each of your exceptions.

If SKU <> "AU9929-ASST" or SKU <> "Exception2" or SKU <> "Exception3" Then

which can get cumbersome as your number of excpetions increases. You may want to switch to using a Seclect Case statement to make this a little easier to manage as your exceptions change, etc.

HTH