Thread: Copy across row alpha - not numeric.
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default Copy across row alpha - not numeric.
=CHAR(64+COLUMN(A1))

Will that do?

Mike

"laralea" wrote:

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,RO W(B1),4,1))-1)

Thanks!
Reply With QuoteReply With Quote