ascending numbers with text

**mlv77** · 08-20-2012, 11:41 PM

Hi all. Very new to excel. Great tool, just beginning to learn the language. I needed to learn how to make ascending number which I did, buy typing a number into a1 then the next highest in a2 the next highest in a3, highlighting the three and then clicking on the box in the lower right corner and dragging down. Voila! the numbers ascend. I need it to ascend with text in the same cell, which will help manage my sites and incoming messages. basically I'm trying to place [email protected], and have the number ascend to [email protected] and so on. Any advice???

**MarvinP** · 08-20-2012, 11:49 PM

Hi mlv77 and welcome to the forum,

Put this in A1 and pull the right lower corner down.

Please Login or Register  to view this content.

Is that close to what you want?

**mlv77** · 08-21-2012, 01:05 AM

MarvinP You're a genious. Thank you. That was avery warm welcome to the forum. that's exactly where I was wanting to go with this. it ascended from one to the desired number with the text. Is there a way to to do the same except for begin with what ever number I choose first and it ascend from there?