Sub test()
For Each cel In Range("A1:A27").Cells
x = CStr(cel): x = Replace(Replace(Replace(Replace(Replace(x, " ", ""), ".", ""), "-", ""), ",", ""), "+", "")
If Len(x) >= 9 Then
x = Right(x, 9)
If Left(x, 2) = "33" Then x = Mid(x, 3)
cel.Offset(, 1) = x & " bizarre"
Select Case Left(Val(x), 1)
Case 6, 7: cel.Offset(, 1) = "0033-" & x
Case 1, 2, 4, 5, 8: cel.Offset(, 1) = Format(Val(x), """0033-""@-@@@@@@@")
End Select
End If
Next
End Sub