Find & Replace

  • Thread starter Thread starter Orville
  • Start date Start date
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.
 
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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MS word Find and Replace using Regex - Help required 0
Excel VBA to match positive and negative transactions 3
Numbers change in cell even when formatted as text 4
Access Dcount (multiple criteria) 3
Windows 10 One of my previous builds is experiencing random, multiple BSODs 9
Find and Replace 1
Text in Cell Formatting 5
Automated Solution to Repair PST Files 2

Back
Top