Hi!

Maybe something like this:

=SUBSTITUTE(A1,B1,"")

Biff

"dcozzi" wrote in message
...
I have an formula that returns a text filed. I would like to then take the
value that was search and return it in another cell with out the
perviously
calculated text value

The result i want is in cell C1

A B C

1 ABCD C ABD