Excel question

fmohyel

New Member
Joined
Apr 14, 2019
Messages
1
The first column contains last name, while the second column contains first name. How can I merge the two columns and seperate the two names with a comma?
Thank you
 

Michael M

Well-known Member
Joined
Oct 27, 2005
Messages
18,205
Office Version
2013
Platform
Windows
In a 3rd column use
Code:
=A1&","&B1
Drag down as required
 
Last edited:

Forum statistics

Threads
1,082,601
Messages
5,366,571
Members
400,902
Latest member
fathima

Some videos you may like

This Week's Hot Topics

Top