Use Excel to split a column of text

Say you have a list of names and need to copy out the first name, last name and also combine them as a username for example first.last.

1. Copy the list of names to a column in Excel.
2. In the cell to the right of the first entry, type the first name again and press enter.
3. You are now in the cell to the right of the second entry, Hold Ctrl and press E
4. The column will auto-fill with the first name for each row.

You can use this same process for usernames by typing the first and last names with a dot rather than a space then use Ctrl+E to complete the rows below.