Thread: concatenate with arrays
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernd P Bernd P is offline
external usenet poster
  
Posts: 806
Default concatenate with arrays
Hello,

Array-enter into a sufficiently long area with 1 column:
=reshape(TRANSPOSE(A1:A3)&B1:B3)

My UDF reshape you can find he
http://sulprobil.com/html/reshape.html

Regards,
Bernd
Reply With QuoteReply With Quote