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.
|