Thread: Copy across row alpha - not numeric.
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
laralea laralea is offline
external usenet poster
  
Posts: 12
Default Copy across row alpha - not numeric.
you guys rock! thanks for the help!!

"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