Add string of text to a specific point in every cells

[Paul_Hossler]

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:

Do you mean 'sentence' ( starts with a capital letter, and ends with a period, question mark, etc. )

OR

Just insert a new second line between the first and second?

Looking at your example, it appears that a vbLF (char(10) is after the 'sun.'

So you could have something like

As I was walking<LF>
down the street<LF>
etc.

If that's the case, you'd want to search for the first Chr(10) and insert 'string' after that giving

As I was walking<LF>
string<LF>
down the street<LF>
etc.