Hello all,
I have an Excel spreadsheet with a list of wedding invitees, but the
names are in the improper format:

"Lastname, Husbandfirstname and Wifefirstname"

I need to extract out the "Lastname, " into a new column, and then
clean up that column by deleting the ending comma and space (which is
", ").

I think that is clear. I really appreciate your help. I did some
basic searching to try to find an answer, and I learned some things
about string manipulation, but wasn't successful tweaking the formula
to do what I want. Also, I must say I am not clear as to how to APPLY
the formula to an existing column.

Thank you for your time.
AP