Apply for excel patent

Intercept the fIFth character and judge it by if formula. If there are many types, you can use LOOKUP.

For example:

The patent number is A 1.

B 1 input formula = if (-mid (a 1, 5, 1) = 2, "utility model patent" and "other patents").