Splitter is a Microsoft Access add-in that separates human names stored in
a single field
into separate components making it a great tool for fixing poorly
structured tables.
If both first and
last names are stored in the same field, Splitter will split the name
without disturbing your existing data. It does this by creating
new fields and splitting
a copy of the name into the new fields as in the example below. A
wizard guides you through the process. More detail
For more programmatic control of name parsing try our new
companion product
NameParser
which provides developers and Visual Basic/Access power users
with methods to parse name strings in code.
More detail