Find & Replace

O

Orville

Is it possible to run the find and replace option against multiple criteria?
If you can, could someone please list the steps. Thank you.
 
D

David McRitchie

Hi Orville,
Can you be more specific as to what you want.
I think you will need to use a programming solution
to check each cell in a selection.
 
A

AlfD

Hi!

If column B is empty then put tthe formul
=if(A1="Header","Header","Detail") in B1.
Copy it down to the bottom of your data.
Column B should look like what you want, if I understand properly.

If Column B is already in use, insert a new column B and use that.

If the result is what you want, copy the whole of Column B. Then us
Edit>Paste Special and Values and paste it right back on top o
itself.

Al
 
Top