One way:

=SUBSTITUTE(A1," UD","")

In article ,
tjh wrote:

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