Merging two row cells and repeating down a column (not down a row).

New Contributor

I have an excel file of contact names. The first name is in one cell (Cell A) and the last name is in a separate cell (Cell B). They are in the same row. I have over 1600 contact names (or rows) like this. I want the first and last names to be merged with one another in just one cell. How do I do this in the quickest and simplest way?

1 Reply

For Excel >=2013 start typing here


or, more reliable, in C2

=A2 & " " & B2

select from C2 till end of your range and Ctrl+D

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies