FIND THE CALCULATED VALUE OF A CELL AND DELETE IT FROM ANOTHER
 

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

FIND THE CALCULATED VALUE OF A CELL AND DELETE IT FROM ANOTHER
 

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

FIND THE CALCULATED VALUE OF A CELL AND DELETE IT FROM ANOTHER
 

I would recommend using the substitute function.

Add the following to C1

=SUBSTITUTE(A1,B1,"")

Hope this helps.


--
mrice


------------------------------------------------------------------------
mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931
View this thread: http://www.excelforum.com/showthread...hreadid=533842