Forum Discussion
Find and Replace Error
Good morning, I am attempting to Replace content on a column of cells but I get an error. This is a new error that I haven't seen before as I have used this function many times. The workbook is...
Perhaps Look In option shall be Values, not Formulas.
SergeiBaklan It doesn't give me another option when I go to the replace tab. I had looked at that before posting the issue. 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. I have checked and the cells are in General format.
And does "Preview" format in Italic and red is applied to entire cell value or only to the part of the text?
SergeiBaklan I believe it is for the entire cell value. I can't tell that it would be any different.