Hello,

Is there an excel function to reference another cell that only pulls in
characters, values or words that are not a specific value, for example "UD".

Ex.

Cell A1 Cell B1 (formula)

12,345 UD 12,345