Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy data of two cells into one
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy data of two cells into one | Excel Discussion (Misc queries) | |||
Copy data of two cells into one | Excel Discussion (Misc queries) | |||
Copy data of two cells into one | Excel Discussion (Misc queries) | |||
how to copy cells data in every 7th row? | Excel Worksheet Functions | |||
How do I copy data (word) into respective cells when the data bei. | New Users to Excel |