Hi all,

Can you help me out here?

I have a long list of names and job positions downloaded from a database.
Each item in the list is contained in a long string of characters in one single cells.

For instance, I have the following (each line is contained in a single cell)

Doe, JaneSales Manager
Smith, JoeVice President
Parker, MelissaAssociate
[Last name], [First name][job Position]
etc...

I can easily separate the last name from the rest of the cell but I am unable to separate the first name from the job position.

Is there any code I should run or any simple Excel sequence I could use to separate the first name from the job position? Maybe something that tell Excel to separate based on small cap/large cap?

Thank you,

Mondello