ExcelBanter - Combining Content of two cells

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Combining Content of two cells (https://www.excelbanter.com/excel-discussion-misc-queries/203460-combining-content-two-cells.html)

FormulaQuestioner

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?

JP[_4_]

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?

Ron Rosenfeld

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

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