Fill Handle

[Leeba]

I need Excel 2007 to do the following:
23493-A
23493-B
23493-C
I entered the alphabet as a new list. It works alone, but when I put a
number and dash before it, it does not work.

 

[Ashish Mathur]

Hi,

You may try this. This assumes that you want the answer in row 2. If you
want the answer in row 7, then then 63 would become 58 I.e. the sum of the
first row and another number should be 65. You may now copy this formula
down

="23493-"&CHAR(ROW()+63)

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

 

[Joe User]

I need Excel 2007 to do the following:
23493-A
23493-B
23493-C
I entered the alphabet as a new list. It works alone,
but when I put a number and dash before it, it does
not work.

If you put 23493-A into A1, then put the following in A2 and drag down:

=LEFT(A1,6) & CHAR(CODE(RIGHT(A1,1))+1)

 

[trip_to_tokyo]

Hi Leeba try this in EXCEL 2007. It may be the solution for you.

1. In cells A 1 to A 3 inclusive I have:-

23493-
23493-
23493-

2. In cells B 1 to B 3 inclusive I have:-

A
B
C

If you can get this to work OK just fill the cells below this in column B
(for example).

3. In cell C 1 to C 3 inclusive I have:-

=CONCATENATE(A1,B1)
=CONCATENATE(A2,B2)
=CONCATENATE(A3,B3)

4. So if you fill columns A and B first of all with the data that you want
and then copy the formula in cell C 1 down that column I think that you will
arrive at the solution you require.

If my comments have helped please hit Yes.

Thanks.

 

[Rick Rothstein]

What did you want to happen after the last character reaches the letter
"Z"... what should go in the next cell?

 

[Roger Govier]

Hi Leeba

Enter this formula into any cell and copy down
="23493-"&SUBSTITUTE(ADDRESS(1,ROW(A1),4),"1","")

--
Regards
Roger Govier

I need Excel 2007 to do the following:
23493-A
23493-B
23493-C
I entered the alphabet as a new list. It works alone, but when I put a
number and dash before it, it does not work.

__________ Information from ESET Smart Security, version of virus
signature database 4755 (20100108) __________

The message was checked by ESET Smart Security.

http://www.eset.com

__________ Information from ESET Smart Security, version of virus signature database 4755 (20100108) __________

The message was checked by ESET Smart Security.

http://www.eset.com

 

[Teethless mama]

This formula can handle up to 16384 rows in Excel-2007

="23493-"&SUBSTITUTE(ADDRESS(1,ROWS($1:1),4),1,)

Drag the formula down as far as needed.