I have a number of spread sheets that are a list of contacts. The problem is that the name column is the full name and can contain mr, mrs, miss with an initial and surname or with a first name and surname.
I would like to extract the first name from each entry and place into an adjacent column cell. I want to be able to apply the formula for myself.
i am quite sure to do this job according to your requirements.i will wait for your positive [url removed, login to view]