Macro that removes word based on characters in cell

[wonderd]

Hello All. Could someone show me a macro that will remove the word "CRISP" from all cells that have over 25 characters in Row A. If the cell has 25 characters or less than then it does nothing. A space would be considered a character.

[stnkynts]

Please Login or Register  to view this content.

[jindon]

Helps?

Please Login or Register  to view this content.

[wonderd]

How would the below macro look If I wanted it to function like so. Remove all cell contents and replace with "Hello my name is" if the character count is over 25?

Please Login or Register  to view this content.

[wonderd]

Bump. Sorry marked the thread as unsolved. Have a similar question.

[stnkynts]

Please Login or Register  to view this content.

[stnkynts]

Please Login or Register  to view this content.

[wonderd]

Actually I am not looking to use the word CRISP at all. The function should just be if any cells in row A has over 25 characters then delete all content in the cell and replace the cell content to "Hello my name is"

[wonderd]

So instead of replace the word CHRISP. It would replace all content in the cell with over 25 characters with with "Hello my name is" I am trying to figure out how to do it with the code below but can not figure it out.

Please Login or Register  to view this content.

[stnkynts]

Please Login or Register  to view this content.

[wonderd]

I appreciate the help but not the sarcasm. My initial post was right but I did not want to create another thread for a similar question...I needed both macros. I guess I wont try to be so friendly next time, maybe that was my mistake.