Hello all,

I am working in a 9000 line spreadsheet where one of the cells contains name information that I need to put into a separate column

Few examples:


AllSource Smith, Peter 01/01/12
Flexible Staffing Luman, Thomas 02/05/12
OnBoard Services Wilmoth, Nicole01/29/12
Robert Half InternationalTsang, Dexter 05/06/12
At-Tech Vega, Joel 04/15/12

As you can see, most of the cells are different in some regard making it difficult to use text to columns or replacing. The thing that all of the cells in the column share is a "Lastname, Firstname" somewhere in the cell. I was wondering how I can just pull the name from these cells, such as:

Smith, Peter
Luman,Thomas
Wilmoth, Nicole
Tsang, Dexter
Vega, Joel

Thank you all, and please go easy! This is my first post.

Scott