OK that is one hell of a confusing title.

What I have is 500 city names with 10 variations on the description. For example: Come and visit [City] find everything you need for a fantastic trip here

I want to randomly apply these 10 variations to the 500 cities but also replace [City] with the relevant city name.

I was hoping to use a macro as it's something I will be doing a lot over the next few weeks for thousands of values. Doe anyone have any idea if it's possible and also how to do it, I have no issue using 2 macros either.

If you need any more information please let me know.

Thanks,

Rhys