Excel Function

M

mark1

I want to have a text string and a number in my formula,
so that when I copy down, the text string will stay the
same, but the number will change. This is what I've got:

="Part" & 1

Copies down as Part 1. I want Part 2, Part 3, etc.,. Is
there a function for this, maybe?

Thanks in advance for the help!!
 
P

Peo Sjoblom

Just type Part1 without any equal sign and copy down.

--
For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom
 
Top