Hey everyone.

Say I have a column A with 100 cells containing a paragraph of text, lets suppose something like this:

Remember when you were young, you shone like the sun.
Now there's a look in your eyes, like black holes in the sky.

Say I want to ad in every cells a string of text, a variable that will change on every addition, between first and second sentences, like this:

Remember when you were young, you shone like the sun.
string
Now there's a look in your eyes, like black holes in the sky.

I suppose I have to search for "now there's" text and add the value of the string before it.
How can I solve this with VBA?