answer:Assuming you have a space or comma between the first and last names, you can use Data / Text to Columns. (I’m still using Excel 2000, so your commands on a more recent version may be different, but the functionality should still be there.) Unless all of your Firstname Lastname combinations are the same length, then choose “Delimited” and select your delimiting character/s, such as “space”, or comma, or whatever it is. The text will be broken into separate columns automatically.