Forum Discussion
Merging contents of items in one column to another without losing data
Better if you attach screenshot directly to your post, not everyone will click on the link of unknown source. Even more better to attache simple sample file - from ones who check the screenshot not everyone will repeat it in Excel to illustrate the formula.
You may combine columns into third one with IF() formula applying the logic
if first column cell is empty
then second column cell value
else first column cell value
Enter it for first row, after that select third column till end of the range and Ctrl+D.
Better if you attach screenshot directly to your post, not everyone will click on the link of unknown source. Even more better to attache simple sample file - from ones who check the screenshot not everyone will repeat it in Excel to illustrate the formula.
You may combine columns into third one with IF() formula applying the logic
if first column cell is empty
then second column cell value
else first column cell value
Enter it for first row, after that select third column till end of the range and Ctrl+D.
My apologies, but I still don't understand how to do this, your help is most appreciated. I am trying to merge two columns, one has first, the second has last name.
N
You wrote to @Sergei Baklan
My apologies, but I still don't understand how to do this, your help is most appreciated. I am trying to merge two columns, one has first, the second has last name.
My first response to you is that you are asking a totally different question from the one that's first in this thread, and for that you should really start a new thread.
Next, to answer your question: to combine first name with last name, assuming first is in column A and second is in column B you could use either of the following, and then copy down to all succeeding rows as needed:
=CONCATENATE(A1," ",B1) which will yield "John Smith"
or
=A1&" "&B1 with the same result
If you want the new column to be Last, First (so as to be able to sort alphabetically by last name)
=CONCATENATE(B1,", ",A1) or
=B1&"' "&A1
But for future reference, please start a new thread ESPECIALLY when you're responding to something that is nearly a year old.
