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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
I would recommend using the substitute function.

Add the following to C1

=SUBSTITUTE(A1,B1,"")

Hope this helps.
 
Back
Top