Hi guys,

I'm not exactly new to excel but what I'm going to ask could be considered as a newbie question.

So let's get things started.

Lets say I have something like :

And the list goes on.

What I want know is, how do I remove the name leaving only their job title behind?

I actually want it to be replaced like below :

I have tried using find and replace where I find " ? (*) " and replace with "*". However, I do not think it's just possible as the whole thing would be replaced with * instead of the wildcard that is defined.

A little help guys?