special characters
 

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

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

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

"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

To return a number as opposed to text

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

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"tjh" wrote in message
...
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