Thread: Copy across row alpha - not numeric.
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
excelent excelent is offline
external usenet poster
  
Posts: 695
Default Copy across row alpha - not numeric.
=LEFT(ADDRESS(1,COLUMN(A1),4,1),FIND("1",ADDRESS(1 ,COLUMN(A1),4,1))-1)


"laralea" skrev:

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