Macro to create a new line within a text string if specific characters appear mid-string

hi everyone,

I have the following code:

Please Login or Register  to view this content.

What this code is supposed to do, is go through each cells in the ranges specified. If the text strings in the cell contains a && the a new line after the && is created and bringing the remaining string to the right of the && with it. I do not get an error with this only, only it doesn't actually seem to do anything.

So here's the effect:

Current (in a single cell):
The sun is out && The sun is out

Desired result (in a single cell):

The sun is out
The sun is out

Any ideas?

Thanks everyone!

Olly,

You, good sir, are a genius. Thanks very much