Forum Discussion
Merging two row cells and repeating down a column (not down a row).
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...
For Excel >=2013 start typing here
or, more reliable, in C2
=A2 & " " & B2
select from C2 till end of your range and Ctrl+D