Hi there...

I am a newbie!! I have a problem that I am trying to get around. I have a list of names of clients and their full name appears in one cell. The format is

Smith, John.

I want it to appear in two cells as first name and last name. Anyone any ideas as to how I can do this?

Frank