combining 2 pieces of text from 2 columns

  • Thread starter Thread starter alexy
  • Start date Start date
A

alexy

Column A has first names, and B second names.
I want C to list the 2 names together, how do I do this?

thanks, Alex.
 
Hi Alex

Assuming you have put one blank space after the first name, in column C you
can use the following:-

=CONCATENATE(A1,B1)

If you haven't, when using the formula wizard select CONCATENATE and in the
Text1 box, select the cell A1 and put one blank space after it

Hope this helps you.

Ellie
 
Good morning Alexy

Either of these two will do the trick:

=CONCATENATE(A1," ",B1)
=A1&" "&B1

HTH

Dominic
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

combining columns and using concatenate 5
Replace data in a column 1
Adding up total hours worked on employee schedule using various criteria 0
Match Account ID from combining street names and numbers 1
Multiple List Analysis 0
Count if 2 criteria are met 1
Excel Comparing two columns 1
How to combine several successive rows into one cell 2

Back
Top