I take it there is a space or comma between surname and initial? If so, try this.
Highlight your column. Choose Data, Text to Columns.
This opens the Convert text to columns wizard. Choose a data type of delimited and then Next.
Choose either space or comma depending on how your data is formatted.
Click Finish. How's that?