Separate Names into Columns

[bulbul4u]

Hello Everyone,

Currently, I have ONE column for the Last name, first name, and Middle name.
My boss wants to have last name, first name, and the middle name in 3 different columns. How can I do that?
The current name column has this name format (Baldwin, Sonia Laci). Where Baldwin is the lastname, sonia is the first name and Laci is the last name.

How can I separate the names into different columns?

Please someone help.



Thank you,

[kennejd]

I created a query and use the mid/left functions in combination with instr. You may need to add some additional checking for people that don't have middle names:

SELECT People.FName, Left([fname],InStr([fname],",")-1) AS [Last], Mid([fname],InStr([fname],",")+2) AS FirstMiddle, Left([FirstMiddle],InStr([FirstMiddle]," ")-1) AS [First], Mid([FirstMiddle],InStr([FirstMiddle]," ")+1) AS Middle
FROM People;


Jim

[bulbul4u]

thanks that worked great!!!!