Adding a number to text

**sponge_designs** · 12-08-2009, 01:52 PM

I have...
="WCSS " &1

which reads as...
WCSS 1

now I need it to continue down the column, adding 1 each time, ie...
WCSS 1
WCSS 2
WCSS 3
etc etc

Thanks for the help

**darkyam** · 12-08-2009, 01:57 PM

If it's in Row 1, try ="WCCS "&Row() and drag down.
If it starts in Row 2, ="WCCS "&Row()-1, etc.

**DonkeyOte** · 12-08-2009, 01:59 PM

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.

(in essence you have the same answer in both)