| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy data of two cells into one
One way:
C20: =C5 & "@" & C6 & " a, b, c" In article , 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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copy data of two cells into one
Thank you JE. It is exactly what I need.
Maperalia "JE McGimpsey" wrote: One way: C20: =C5 & "@" & C6 & " a, b, c" In article , 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 |
| 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) | |||
| how to copy cells data in every 7th row? | 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 | |||
Hybrid Mode
