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