Add text to a cell that already contains text based on if another cell contains a word

I need a macro that will add the text ",Convenient" to a cell that already contains other text in column B if a cell in column A contains the word "mobile". The word "mobile" could be upper or lower case. Also, the text ",Convenient" would be appended to the end of the already existing text in that cell; example: "Auto,Convenient". I may have up to 50,000 rows to check and so it will loop. Skip any row that doesn't contain the word "mobile" in column A. Here's an example of the spreadsheet before and after:

Before:

A	B
ABC Car Wash	Auto
Cleanz Mobile Detailing	Auto
Mobile Oil Change Bros	Auto
Jacks Car Repair	Auto
Jim's Dent Repair mobile	Auto

AFTER:

A	B
ABC Car Wash	Auto
Cleanz Mobile Detailing	Auto,Convenient
Mobile Oil Change Bros	Auto,Convenient
Jacks Car Repair	Auto
Jim's Dent Repair mobile	Auto,Convenient

Thank you kindly for your help!

How about

Please Login or Register  to view this content.

Question: Is it possible for the word "mobile" to be in a cell in Column A and the adjacent cell in Column B be blank? If so, should the cell in Column B remain blank or have the single work "Convenient" be placed in it all by itself?

If the cell in column B is blank then we want to add "Convenient" without the ",".

In that case, how about

Please Login or Register  to view this content.

Hi Fluff13,

The macro didn't work for me. My current spreadsheet is looking for "mobile" in column A and needs to put ",Convenient" in column AB. Please advise.

Thank you!

It's always best not to simplify your needs, otherwise you get something that doesn't work.
How about

Please Login or Register  to view this content.

Thanks for the advice . That worked! Now, if for some reason I needed to run the macro twice (its one of many macros being run at the same time and I do run it twice in some cases) and I wanted to prevent it from adding ",Convenient" a second time, how would I need to alter the code? Thanks again for all your help!

Any other requirements?

Nope, that's the last one.

In that case try

Please Login or Register  to view this content.

Thank you Fluff13 I really appreciate the help. That worked perfectly.

You're welcome & thanks for the feedback.