Split Comma Separated Names

Version 1

    The below details how to split a comma separated name into its constituent parts.

    You can use the below formulas to split the first name from the last name (in my example the source field is called Name)

     

    If your source data is in the following format: Last Name, First Name

     

    First Name: right([Name],(len([Name])-find([Name], ",")-1))

    Last Name: left ([Name], find([Name], ",")-1)

     

    OR

    If your source data is in the following format: First Name, Last Name

     

    First Name: left ([Name], find([Name], ",")-1)

    Last Name: right([Name],(len([Name])-find([Name], ",")-1))


    Example workbook attached.


    Cheers

    Mark