Learn how to separete ot split the Full name to First and Last name in Microsoft Excel, using the Delimiter or Separator function or Formula.

Excel gives you two ways to split cells into columns: using delimiters, or using a manual fixed width. Splitting cells into columns is a convenient way to separate first and last names, or cities ...

Microsoft Excel has numerous powerful data analysis functions, but sometimes you need to do something simple like merge some cells. Here's how.

Press "Ctrl-X" to cut the cells. Click just beneath the last data cell in the first column. Press "Ctrl-V" to move the second column's data to the bottom of the first column.

If you need to add a comma after the first word in each cell in Excel using the Replicate or Substitute function, read through this article.