View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Bob I Bob I is offline
external usenet poster
 
Posts: 2,819
Default Copy data of two cells into one

=C5&C6&"a, b, c"

maperalia wrote:

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