Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 29
Default Combining Content of two cells

I am sure this is a very easy thing to do. How do I combine the content of
two cells. If there is Column A of first name and Column B of last name. How
do I have Column C of both names?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5,651
Default Combining Content of two cells

On Mon, 22 Sep 2008 18:36:04 -0700, FormulaQuestioner
wrote:

I am sure this is a very easy thing to do. How do I combine the content of
two cells. If there is Column A of first name and Column B of last name. How
do I have Column C of both names?


=a1 & " " & b1
--ron
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 897
Default Combining Content of two cells

Space separated:
=A1&" "&B1

Comma separated:
=A1&","&B1

--JP

On Sep 22, 9:36*pm, FormulaQuestioner
wrote:
I am sure this is a very easy thing to do. How do I combine the content of
two cells. If there is Column A of first name and Column B of last name. How
do I have Column C of both names?


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
Combining Cell Content PaolaAndrea Excel Discussion (Misc queries) 2 May 9th 08 06:52 PM
Merge content of cells Arne Hegefors Excel Worksheet Functions 2 January 4th 07 03:29 PM
Combining formulas, "and" & "or" to verify content of multiple cel Shu of AZ Excel Discussion (Misc queries) 15 October 15th 06 11:22 PM
Clear Cells Content No_Spam Excel Discussion (Misc queries) 2 August 20th 06 04:01 PM
Combining cell contents when there is content to combine Richard Excel Discussion (Misc queries) 2 June 21st 06 07:30 PM


All times are GMT +1. The time now is 05:53 PM.

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

About Us

"It's about Microsoft Excel"