Fill Handle

  • Thread starter Thread starter Leeba
  • Start date Start date
L

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.
 
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
 
Leeba said:
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.
Click to expand...

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)
 
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.
 
What did you want to happen after the last character reaches the letter
"Z"... what should go in the next cell?
 
Hi Leeba

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

--
Regards
Roger Govier

Leeba said:
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
Click to expand...

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

The message was checked by ESET Smart Security.

http://www.eset.com
 
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.
 
Back
Top