Super Formula Bar (easily edit multiple lines of text and formula) Reading Layout (easily read and edit large numbers of cells) Paste to Filtered Range.Reuse: Quickly insert complex formulas, charts and anything that you have used before Encrypt Cells with password Create Mailing List and send emails.The Best Office Productivity Tools Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by Split full name into first name middle name and last name

Now the selected names have been split into two columns and one column with first name and another with last name separately. Click Ok and select a single cell to put the result.Ĥ. In the popping dialog, check the options as you need, if there are some middle names in your list, you can check the Middle name option, too. Select the column of names, and click Kutools > Merge & Split > Split Names. In this case, you can use Kutools for Excel’s Split Names utility to quickly split names into cells.Īfter installing Kutools for Excel, please do as below: （Free Download Kutools for Excel Now!)ġ. Kutools for Excel, with more thanģ00 handy functions, makes your jobs more easier.īut in some case, when you have a single column with first name and last name in each cell, maybe now you want to split them to two cells, one includes first name, and another includes last name as below screenshot shown: With the Kutools for Excel's Combine Rows, Columns or Cells without Losing Data tool, you can quickly combine content from multiple columns (or rows) into one column (or row) without losing original data. You can use the formulas of =A2&' '&B2 with the same steps as above to get a full name roster by combining first name column and last name column. Then you will get a single full name column with combining the first name column and last name column. Step 2: Press Enter key and click the Cell C2, then drag the fill handle to copy the formulas across the range that you want to fill.

Step 1: In a blank cell, such as C2, enter the formulas of =Concatenate(A2, ' ',B2), see screenshot: There are two functions that can combine the first and last names into one cell quickly. Split first name and last name into two cells with Kutools for Excel Combine the first and last names with functionsĬombine the first and last names with Kutools for Excel

How to merge cells in numbers for mac