VB Code to split out Last Name, First Name

Hello

Please refer to attached file.
I need VB Code to Split out Last Name, First Name and SS# as shown in Column D,E and F for source in column C


Let me know if you have any questions.
Thanks.
Riz

If last name would always be the 1st set of nonblank characters, immediately followed by a comma, a space, the 1st name as the next set of nonblank characters, a space or newline, the 2 words Soc Sec#, space and ###-##-####, then for the VBA variable c set to cell C2,

Please Login or Register  to view this content.

This sets D2 to the last name, E2 to the 1st name and F2 to the Social Security number. Put that in a loop to generalize.