Ronald

Note on PROPER() Function.

If you have names with Mc or Mac or like van der Meer PROPER() won't do the
trick.

You will wind up with Mcdonald or Van Der Meer.

David McRitchie has VBA code that will look after many of these.

http://www.mvps.org/dmcritchie/excel/proper.htm


Gord Dibben Excel MVP

On Mon, 31 Jan 2005 11:23:18 -0500, "Paul B"
wrote:

Ronald, use the proper function, like this, =PROPER(A1) than you can copy
and paste special valves back over you data