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 <4DC6468D-C1C0-4504-A730-AA9512158BA3@microsoft.com>,
tjh <tjh@discussions.microsoft.com> 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" <tjh@discussions.microsoft.com> wrote in message
news:4DC6468D-C1C0-4504-A730-AA9512158BA3@microsoft.com...
> 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
>
>
>