Question description:
This user has given permission to use the problem statement for this
blog.
I need to combine a column of first names and a column of last names into one "Full name column.
Solved by C. B. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
04/05/2018 - 07:25
Hello
Excelchat Expert
04/05/2018 - 07:25
Welcome to got it pro
User
04/05/2018 - 07:25
Hello! I need to combine a column of first names and a column of last names into one "Full name column.
Excelchat Expert
04/05/2018 - 07:25
Okay.
Excelchat Expert
04/05/2018 - 07:25
I am gonna show you how to do it.
User
04/05/2018 - 07:25
Awesome!
Excelchat Expert
04/05/2018 - 07:27
Please look at the preview window, is that what you want?
Excelchat Expert
04/05/2018 - 07:28
Hello, are you there?
User
04/05/2018 - 07:29
I'm so sorry I had to step away I'm back now!
User
04/05/2018 - 07:29
But yes that is exactly what I need to do except for a whole column of 500 names
Excelchat Expert
04/05/2018 - 07:30
not a problem. The formula is =A2&" "&B2
User
04/05/2018 - 07:30
I've been trying that and hasn't worked
Excelchat Expert
04/05/2018 - 07:30
you have to adjust the A2 and B2 with your actual column reference.
Excelchat Expert
04/05/2018 - 07:30
That's strange, can you send me the file?
User
04/05/2018 - 07:34
It's working a little better. Am I able to apply it to a whole column?
Excelchat Expert
04/05/2018 - 07:34
Yeah, you can do that.
User
04/05/2018 - 07:35
How?
Excelchat Expert
04/05/2018 - 07:36
When you place your mouse pointer on a cell, do you see the little box at the bottom right corner of that cell?
Excelchat Expert
04/05/2018 - 07:36
If you do, double click on it.
Excelchat Expert
04/05/2018 - 07:38
[Uploaded an Excel file]
Excelchat Expert
04/05/2018 - 07:38
Please see the screenshot for a reference to what I was talking about.
Excelchat Expert
04/05/2018 - 07:40
any problem there?
User
04/05/2018 - 07:40
Yes hang tight will send screenshot
Excelchat Expert
04/05/2018 - 07:40
okay.
Excelchat Expert
04/05/2018 - 07:44
I see you have opted against to extend time, hence the session will end now. .
Excelchat Expert
04/05/2018 - 07:44
Thanks for trying out got it pro, have a great day ahead!
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.