How to highlight certain keywords that I search.

What options are you considering? If you simple apply a filter to the column and then filter with "contain" and put in LLC and all those with LLC will come up.
you can use a search in the next column to find LLC or Trust or Company and put something in that column then filter on those then delete.
You can do a find and replace, find what >> LLC replace with >> leave blank but this will only remove LLC from a cell leaving the rest in place.
You cannot use a formula to delete things, that can only be done with VBA (a different section of this forum) and if that is what you want you might want to private message a moderator or administrator asking to move this post to the VBA forum.
So what is it you are looking to do, just get rid of LLC from a cell or get rid of the whole cell?
Lastly, check the yellow banner at the top of the post and upload a small representative sample WITH expected results and which way you'd like it done.

columns go up and down and are column A and B etc.
rows go across. If you don't want to do it by formula and filter see the attached sample. I added a formula in a helper column G with examples I highlighted in yellow.
this formula in G
=IF(ISNUMBER(SEARCH("LLC",F2))=TRUE,"Delete",IF(ISNUMBER(SEARCH("company",F2)),"Delete",IF(ISNUMBER(SEARCH("trust",F2)),"Delete","")))
To get VBA you'll need to message a moderator and ask it to be moved.
I do not have VBA skills.
to use what I've attached, just filter on "Delete" in column G you can sort on that column moving those to either the top or bottom and then delete them in a batch.

Paste this code in to a Macro Module and Run the Macro "Test"

Please Login or Register  to view this content.

If you are able to answer the questions that were posted in your other duplicate thread which has now been closed by the Moderator, we may be able to help.

If you are asking me. Then yes. As long as you have a max of 6 columns of data.

You can have as many rows as you want.

If you want more, or a variable number of columns.

Then please let me know.

I get that message if I click on the button twice. ie if I run the macro twice.

Please try again.


Alternatively. This version has some error trapping.


NB this part of the code is your list of items to delete:

Please Login or Register  to view this content.

So you need to change that to

Please Login or Register  to view this content.

Please Login or Register  to view this content.

@newbie, (Post #11) it worked for me in the sample workbook you posted, to repoint it to different cells just make the adjustments to the formula, you can see it in what I reposted which was just your data. When you say it doesn't work for you, more details would be helpful. Maybe a sample showing where you are using it and what it is pointed to so I can see why it isn't working. (that is if you aren't using mehmetcik's solution.)

Hi.

Ok I am attaching a sample workbook.

I have highlighted two rows that need to be deleted.

Open the workbook. You will need to enable editing and also macros.

Once open. Check that you agree which two rows need to be deleted.

Then click on the button in cell. I3.

Please Login or Register  to view this content.

This works for column A of any file.

If you want to use it for multiple files then you should place it into your Personal Workbook.

This is a bit complicated but worth doing.

I will talk you through the simplest way to do this.

To start with decide on a short cut to start the macro. Lets go for Ctrl z.

So whenever you type Ctrl z. the macro will run.

Next Select the Developer tab and Select "Record Macro"

Enter this data into the window that opens.

Macro Name: TidyUp
Shortcut Key: z
Store Macro in: Personal Macro Module
Description: Delete Text: Properties, LLC

Select Ok to start the macro recorder. Excel will now record all your keypresses. This is the easiest way to start creating a Macro.

Next Select the Developer tab and Select "Stop Recorder"


Next Select the Developer tab and Select "Macros" Select "TidyUp" and then "Step Into"

You Should see a Short Macro.

Paste your Macro inside this Macro. Remembering to delete the first and last lines of your original macro.

Now very carefully. Close the macro module.

very carefully. Close Excel using the close button on the top right of Excel. MAKE SURE you Select "SAVE CHANGES TO PERSONAL MACRO"

Now open any excel workbook

Select any sheet with text in Column A. Press Ctrl z.

Did you manage to find your personal workbook?

Try Deleting your temporary Macro.

Then paste this code in the personal workbook, Close the module and close excel. Remember to save changes to the Personal workbook.

Please Login or Register  to view this content.

Delete everything in the personal workbook and try again

My code has one sub and it ends with end sub.

Please Login or Register  to view this content.

Ok I have spent hours on this.

Read this link:

https://www.myonlinetraininghub.com/...-xlsb-workbook

Although you can run macros on your personal workbook. Microsoft have made changes that mean it is difficult/impossible to run functions on the personal workbook.

I tried to get this working here so I could talk you through it and failed.

However I am stubborn and will keep trying.