Thread: CONCATENATE
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Joe User[_2_] Joe User[_2_] is offline
external usenet poster
 
Posts: 905
Default CONCATENATE

"Tservo" wrote:
I would LOVE to combine cells from the same
column instead of cut & pasting information.
- example D132 through D147 and have this
combined information appear in D132. Is this
possible?


=D132 & D133 & ... & D146 & D147

You can separate the cell contents by concatenating strings. for example:

=D132 & " " & D133 & ... & D146 & " " & D147

Obvious, this is tedious for a large range like D132:D147. The CONCATENATE
function does not accept ranges either.