Find and Replace Error

Question

Good morning,&nbsp;I am attempting to Replace content on a column of cells but I get an error.&nbsp; This is a new error that I haven't seen before as I have used this function many times.&nbsp; The workbook isn't protected so I don't know how to get around this or how to fix the issue.&nbsp; Any help would be greatly appreciated.&nbsp;&nbsp;

sergeibaklan · Answer

AKerley1128&nbsp;
Perhaps Look In option shall be Values, not Formulas.&nbsp;

akerley1128 · Answer

SergeiBaklan&nbsp;It doesn't give me another option when I go to the replace tab.&nbsp; I had looked at that before posting the issue.&nbsp; When I do the find tab, the cells are already set as values but when on the replace tab it only gives me an option of formula.&nbsp; I have checked and the cells are in General format.&nbsp;&nbsp;

sergeibaklan · Answer

AKerley1128&nbsp;
And does "Preview" format in Italic and red&nbsp; is applied to entire cell value or only to the part of the text?

akerley1128 · Answer

SergeiBaklan&nbsp; &nbsp;&nbsp;I believe it is for the entire cell value. I can't tell that it would be any different.

Forum Discussion

Find and Replace Error

4 Replies