Greetings!

I've perused about 50 pages across the Forum and haven't found anything similar to use or glean to do what I would like to accomplish. I used to know how to do this (in my youth, with Supercalc3 and Lotus 1-2-3) and drawing blanks when it comes to Excel 2007.

I have a column with my prospects "Gender" - with answers of either "M", "F" or Blank, for Male, Female on Unknown (unverified, actually).
I'd like to create a macro or formula to read and convert a copy of that Column to "Mr.", "Ms." or to leave blank (as is) if blank.

I've played around with the "=IF" formula but have gotten stuck.

I would appreciate any direction or guidance to this basic Excel formula problem. Thanks!

Regards,

Dan