peltier tech utilities
Learn how to create Excel dashboards.

Categories

30 Excel Functions in 30 Days

Archives

Excel Twitters 20090327

Moved to the Excel Twitters archive:

Excel Twitters 20090327

Split First and Last Names in Excel

If you have a list of names in Excel, with first and last names separated by a comma, you can use an Excel feature to split the first and last names into separate columns.

Select the List

To start, select the cells that contain the names.

On the Ribbon in Excel 2007, click the [...]

Related Posts Plugin for WordPress, Blogger...