-
Add string of text to a specific point in every cells
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?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules