Mix number with text as text

I have this in a cell : “collection1” (without quotes)
when I copy it down the column I get the ‘1’ incremented by one with each row.
so that when I get 20 rows down I get: “collection21”

How do I get it to simply take the whole string as a text string?

So that it always remains “collection1” ?

I googled and got suggestions about quotes around the string and about an apolstrophe before the number and neither one those worked. I just got the quotes and the apostrophe showing up in the string and the number still incremented.

Hold down Ctrl while you drag

cripes, so incredibly easy! thanks a lot. :slight_smile: