Thread: Copy across row alpha - not numeric.
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Roger Govier Roger Govier is offline
external usenet poster
  
Posts: 2,886
Default Copy across row alpha - not numeric.
Hi

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

--
Regards

Roger Govier


"laralea" wrote in message
...
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