Categorized information when imported into FileMaker
I have an Excel spread sheet with a list that includes Names, Business, and Attorney firms. I would like to know how to break up the name to first, last, and middle initial.
I also would like to separate out the business name that goes with the person in a designated field in the same record.
And finally separate out the attorney firm that goes with the person also into a designated field in the same record.
Each of these names are on a separate line in and I want them to be in a single record in a designated field.
How do I accomplish this?