Unanswered

Excel - Find and Replace - Look in: Values

(0) Share

Report

Posted on by wezhema

Hello,

I am using the 'Find and replace cells in Excel action' and it is looking for Formulas and not for Values, does anyone know how to replicate that function? (Look in: Values)

Thanks

All responses (3)

Answers (0)

MichaelAnnis 5,721 on at

Like (0)

Report

Re: Excel - Find and Replace - Look in: Values

You cannot replace in values; it would blow out the formulas. Look:

If you are done with the formula and want to replace text after the formula is completed, then select the range, copy, paste values, then use the replace feature (it defaults to formulas, but if it is text, then the formula is the text value).

Best of luck!
VJR 7,635 on at

Like (0)

Report

Re: Excel - Find and Replace - Look in: Values

@wezhema

I just checked and you're right and that's not good.

Maybe in your case does enabling "match entire cell contents" work for you?
MichaelAnnis 5,721 on at

Like (0)

Report

Re: Excel - Find and Replace - Look in: Values

Deleted