Hello. I have a field that has a persons first and last name formatted like this
I need to split them out into to fields in my query.
So - how do I get everything BEFORE the comma in one cell.... and everything AFTER the comma in another cell? also I would like everything after the comma not to have a space between , Firstname.