David McRitchie wrote:

Hi Eric,
If you recorded a macro you would have a very good start.

See http://www.mvps.org/dmcritchie/excel/proper.htm#surname

If not familiar with installing and using a macro see
http://www.mvps.org/dmcritchie/excel/getstarted.htm
and once you've installed and used a macro and have a new macro
question it would be better to post in excel.programming

I tried that but it fails to record when yo do this. Try it, it will
error out of the record mode if you exit the cell after bolding part of the
cell text
Eric