Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
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


  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 258
Default Copy data of two cells into one

Thank you Bob. It is exactly what I need.

Maperalia

"Bob I" wrote:

=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



  #3   Report Post  
Posted to microsoft.public.excel.misc
FC FC is offline
external usenet poster
 
Posts: 130
Default Copy data of two cells into one

Thank you FC. It is exactly what maperalia needs.

"maperalia" wrote:

Thank you Bob. It is exactly what I need.

Maperalia

"Bob I" wrote:

=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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copy data of two cells into one Gary''s Student Excel Discussion (Misc queries) 9 June 8th 07 06:10 PM
Copy data of two cells into one JE McGimpsey Excel Discussion (Misc queries) 1 June 5th 07 06:38 PM
Copy data of two cells into one PCLIVE Excel Discussion (Misc queries) 1 June 5th 07 06:38 PM
Copy data of two cells into one Dave O[_2_] Excel Discussion (Misc queries) 1 June 5th 07 06:38 PM
How do I copy data (word) into respective cells when the data bei. awg9tech New Users to Excel 1 January 12th 05 11:26 AM


All times are GMT +1. The time now is 11:08 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"