Redux: Excel tip: Split first name and last name into separate cells- September 1, 2004 In response to my post on splitting names into multiple columns in Excel, someone (who listed themselves as "me") posted the following comment: very interesting, but there is a problem - when you split the names into two or three columns using this method and there are variations of first+last and first+middle+last names within the column, it tends to insert the middle names of those who have them in the same column with the last names of those who don't have middle names, reserving the third..http://blogs.msdn.com/lauraj/archive/2004/09/01/224185.aspx |