F Frank Kabel Apr 12, 2004 #2 Hi have a look at 'Data - Text to columns' also see: http://www.cpearson.com/excel/FirstLast.htm
K Ken Wright Apr 12, 2004 #3 Firstname Lastname only, or Middle initials complicating things. Assuming the former, select the data and do Data / text To Columns / Delimited / Space or comma as delimiter depending on your data and then hit OK
Firstname Lastname only, or Middle initials complicating things. Assuming the former, select the data and do Data / text To Columns / Delimited / Space or comma as delimiter depending on your data and then hit OK
