Hello, I have two sources of data showing names as the following:

- Last, First M
- Last,First M

Not every name has a middle initial so there is not always a first/second space. I need to use the name as a unique identifier and need to either:

- substitute the first space only with "" nothing on the first list, or
- add a space after the comma on the second list

Either option will create a unique identifier to bring information together, and I am stuck on how to make that happen. Any suggestions?

Thanks so much.
Sheryl