Add Nameparser to your project to programmatically parse human names stored in a single field into separate fields, fixing poorly structured tables. Video Overview
If both first and last names are stored in the same column in the table, you can extract name components programmatically without disturbing your existing data. More detail here
Nameparser has its own help file and there is on-line documentation here. All methods, properties and events are detailed and code snippets will get you started.
Watch short video demos of NameParser used with MS Office, Visual Studio and SQL Server Data Transformation Services.
Watch videos here