Copy data of two cells into one
Thank you PCLIVE. It is exactly what I need.
Maperalia
"PCLIVE" wrote:
One way:
=C5& "@" & C6 & " a, b, c"
HTH,
Paul
"maperalia" wrote in message
...
How can I copy information from two cells into another cell.
For example, I have the data "M" in cell C5 and the data "L" in the cell
C6
and I want to copy the following in the cell C20: M@L a, b, c
So, "M" and "L" are always variables and the rest (@ a, b, c) are always
the
same.
Thanks in advance.
Maperalia
|