Dragging across (wierd action)

[Nalani]

1. I typed in A, B, C in row 1
2. Highlighted those cells
3. Grabbed the lower right handle and drged to the right

Alpahabet increased as expected up to G.

In H1:J1 I got the following:

'A', 'B', 'C',

Then in K1:Q1 I got the repeat of Alpha A:G

Then it repeats with the 'A', 'B', "C'

What's going on?

 

[Nalani]

Sorry, this may have slipped through the cracks.

I did read up on Creating a Custom List. And that may have to suffice.
As far as a Formula, I'll look into that, right now don't know if I'm going past Z

Should have said that there may be the possibility. (highly likely)

After Z, I would need AA, BB, CC, etc

 

[shg]

=substitute(address(1, columns($e6:e6), 4), "1", "")

 

[Nalani]

Thank you shg

That did it. I can adjust for my range.

 

[shg]

You're welcome, glad it worked for you.