Thread: split range address into individual cell addresses
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
noname noname is offline
external usenet poster
  
Posts: 97
Default split range address into individual cell addresses
hi,

Given a range say, "A1:E1", i need a formula to return a string of cells "A1","B1","C1","D1","E1". I do not want to use helper columns.

has anyone tried something like this?
Reply With QuoteReply With Quote