special characters

[Guest]

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

 

[JE McGimpsey]

One way:

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

 

[Guest]

=--LEFT(a1,FIND(" ",a1))

 

[Ken Wright]

To return a number as opposed to text

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