Macro to remove certain text string ONLY if comes at first

[ghoneim]

Hi,

I need a macro that helps me check a column of text against a list of given words, remove these words from column cells ONLY when they come at the very first of the cell

Example:
I need to remove the word "learn" from a list of course titles in a column (A2: A100) - only when "learn" show up in the beginning:

learn how to design robots ---------->how to design robots

While if "learn" show up in any other part (middle, or last word):

Explore and learn how to design robots --------> stays the same
Robots designs: Where to learn----------> stays the same


Any help with that?
Thanks in Advance

[gjcase]

How about this:

Please Login or Register  to view this content.

Requires you select the range to be operated on first. If you wanted, you could hard-wire that.

[gjcase]

The above doesn't use a list; the one below does:

Please Login or Register  to view this content.

You need to specify your list of words to be replaced in D2:D6, or revise the macro to point to the correct address.

[ghoneim]

It works exactly the way I need!

Thanks a million gjcase

[ghoneim]

One more thing gjcase..
I wonder how would this code look like if -instead of removing "learn ", adding "ing" to it to become "learning"? Still when comes at first of sentence only
I'd appreciate your response..

Thanks a lot

[gjcase]

Here you are:

Please Login or Register  to view this content.

[gjcase]

Here you are:

Please Login or Register  to view this content.