Copy across row alpha - not numeric.

[Guest]

I found this to copy alpha down, but need help to do this across the row.

=LEFT(ADDRESS(1,ROW(B1),4,1),FIND("1",ADDRESS(1,ROW(B1),4,1))-1)

Thanks!

 

[Guest]

=LEFT(ADDRESS(1,COLUMN(A1),4,1),FIND("1",ADDRESS(1,COLUMN(A1),4,1))-1)


"laralea" skrev:

 

[Guest]

=CHAR(64+COLUMN(A1))

Will that do?

Mike

 

[Roger Govier]

Hi

Try
=SUBSTITUTE(ADDRESS(1,COLUMN(A1),4),1,"")

 

[Guest]

you guys rock! thanks for the help!!

 

[Roger Govier]

Hi Mike

That will work absolutely fine up to column Z, which may well be
sufficient for the OP.

However, you have to add some more conditions to take it on to 256
columns, and another if you are operating on XL2007 to cope with 1024
columns.