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

I have the same question (0)

All responses (3)

Answers (0)

MichaelAnnis 5,721 Moderator on at

Like (0)

Report

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

Deleted

Was this reply helpful? Yes No
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?

Was this reply helpful? Yes No
MichaelAnnis 5,721 Moderator 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!

Was this reply helpful? Yes No