Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
Solved

# How to combine two cells in Excel?

Posted on 2011-05-10
Medium Priority
336 Views
Hi,
I have the following data:

First Name   Last Name
James          Wargo
Craig            Weis

Now, I want to make this:

First Name   Last Name  First and Last Name
James          Wargo        James Wargo
Craig            Weis           Craig Weis

How can I do it?

Thanks,

0
Question by:Tolgar
• 3
• 2

LVL 14

Expert Comment

ID: 35730941
Use this formula:
A1    B1       C1
John Smith  =A1 & " " & A2

sew
0

LVL 14

Expert Comment

ID: 35730945
Formula for C1
``````=A1 & " " & A2
``````
0

LVL 14

Accepted Solution

sungenwang earned 2000 total points
ID: 35730955
mistake... use this formula on C1
``````=A1 & " " & B1
``````
0

LVL 33

Expert Comment

ID: 35730983
You can also use the CONCATENATE() function, like this:

=CONCATENATE(A1," ",B1)

jppinto
0

LVL 33

Expert Comment

ID: 35730989
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…
###### Suggested Courses
Course of the Month14 days, 21 hours left to enroll