Combing the First and Last Names
This post will guide you how to quickly combine the first and the last names into one single cell in an Excel Worksheet. How do I combine first and last name columns in Excel.
Combing the First and Last Names
Assuming that you have a list of data in the range of cells B1:C4 and one column contains the first names and another column contains the last names. And how to combine two columns of first and last names in your worksheet. You can use the concatenate operator to create a formula to join those two names. Like this:
=B2 & " "&C2
Type this formula into the formula box of cell D2, and drag the AutoFill Handle over other cells to join the first and last names.
You can also use the CONCATENATE function to create a formula to achieve the same result. Like this:
=CONCATENATE(B2," ",C2)
Type this formula into a blank cell and then press Enter key in your keyboard, and drag the AutoFill handle over other cells.
In daily work, we may meet the cases that select all blank cells or non-blank cells of a range. You may know the way to select all blank cells as they are “blanks”. But for non-blank cells, they may contain ...
This post will guide you how to concatenate cells but ignore all blank cells in your worksheet in Excel. How do I concatenate cells but ignore blank cells with a formula in Excel. How to create a concatenate formula to ...
This post will guide you how to concatenate cells if same value in another column using an VBA macro in Excel. How do I merge cells if same value exists in another column using formula and filter feature in Excel ...
This post will guide you how to delete or remove year from a given standard date in Excel. How do I remove the year from a date with a formula in Excel. Remove Year from a Date Assuming that you ...
This post will guide you how to combine multiple cells with line break in Excel. How do I concatenate cells with a line break character into one cell with formula in Excel. Concatenate Data with Line Break Character You can ...
This post will guide you how to concatenate cells and keeping data format in Excel. How do I concatenate cells and retain the certain Date format with a formula in Excel 2010/2013/2016. Concatenate Cells and Keeping Date Format Assuming that ...
This post will guide you how to find and highlight duplicate rows in a range of cells in Excel. How do I find duplicate rows in a range with a formula in Excel. How to find duplicate rows in two ...
This post will guide you how to combine multiple cells in one or more columns into one cell with line breaks or Alt +enter in Excel. How do I concatenate different values together into one cell with line breaks. For ...
This post will guide you how to add common prefix or suffix to all cells or the range of cells in your worksheet in Excel. How do I add the same prefix or suffix to a range of cells without ...
This tutorial will teach you how to highlight duplicates rows using conditional formatting feature in Excel. In the previous post, we talked that how to change the color of rows based on a certain number or text or begin a ...
