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.