Thread: How to concatenate a range?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Nathan Gutman Nathan Gutman is offline
external usenet poster
  
Posts: 31
Default How to concatenate a range?
To sum up a range I can use SUM(A1:A30) but cells A1:A30 contain text
(strings).
The function CONCATENATE(A1:A30) does work here.
Is there a simple way to that without having to use Range("A1") &
Range("A2") & ..........Range("A30")?
Thanks,
Reply With QuoteReply With Quote