This effect can be achieved with a formula,
Call the if function, mid function, type function, lookup function, the effect is as shown in the figure.
To determine whether the project column is "patent" or "high-tech", the specific formula is:
=IF(C2lt;gt;"", IF(TYPE(--(LEFT(C2 , 1)))=1, "Patent", "High-tech"), "")
Explanation: Since the number is relatively long and in text format, after extracting the first character on the left, convert it to Number, that is, --left(C2,1); then determine the number type, that is, type(). If the result is 1, it means it is a number, which is a patent; if the result is not 1, it is high-tech.
Column F determines the patent type. The specific formula is:
=IF(D2="Patent", LOOKUP(--MID(C2, 5, 1), {1, 2 , 3}, {"invention", "utility model", "appearance"}), ""),