How do I do this in Excel?

Factual Questions
1

Hi, let’s say I have a set of words like:

1st
2nd
3rd
4th
…
98th
99th
100th

and another set of words like:

meaningful
memorable
sentimental

and 7 more words like that.

What I want to do is create all the permutations of those words to create sentences like, “Meaningful 1st birthday”, “Memorable 2nd birthday”, etc. In the example above there are a total of 1000 permutations. I know how to concatenate sentences together from words in cells, but can I list the words above on one worksheet, and have Excel create the 1000 phrases without me having to create 1000 rows in the spreadsheet and individually piece together the sentences?

Thanks in advance.

2

Know your way around VBA?

3

Sure, I’m pretty sure I could manage if I had a starting point or a nudge in the right direction.

4

Well you are going to end up with 1,000 rows anyway unless you are talking about just making random concatenations.

So all you need is a sheet with first second, third…listed in column A and do the ten concatenations in B to K and copy down:

=concatenate(sheet2!$A$1," “,A1,” birthday")
=concatenate(sheet2!$B$1," “,A1,” birthday") etc