left or substring function

[SAS26]

Hi People,

INFO: Running Excel 2003 SP2

I have a simple problem i'm sure but a bit of a newbie when it comes to excel functions etc.

The problem I have and see picture attached is a column with contact data. As you will see I have Mr/Mrs information + Initial of first name + last name. Not exactly the best way to store data, especially in one col. What I require is to extract the Mr/Mrs/Miss out of this column and insert to the column to the the right for example. I guess a substring or left function is what I need, however not too sure how to go about this.

Something like IF substring = "Mr" then populate column to the right with "Mr" or IF substring = "Mrs" then so on and so forth. So far the column only holds either Mr, Mrs, Miss but would like to be able to add Dr, Hon etc.

Any ideas would be much appreciated.

All the best,

SAS26