Function String Words Class

LastName1stTo1stName1st

"Last-name-first To First-name-first" Converts a name from last-name-first form into first-name-first form. Strings not containing either one or two commas are returned unchanged.

Signature (Visual Basic / VBA)

Public Function LastName1stTo1stName1st( _
    ByVal vName As Variant _
    ) As Variant

Code Example

    LastName1stTo1stName1st("Doe, John") = "John Doe"
    LastName1stTo1stName1st("Doe, John, Jr.") = "John Doe, Jr."
    LastName1stTo1stName1st("Doe, John J., D.D.S.") = "John J. Doe, D.D.S."

Parameters

Parameter Description
vName String containing the proper name which is to be changed from last-name-first form into first-name-first form. Function returns Null if vName is Null or cannot be fixed up to a String.