CAPITALS, Sentence case and Proper

[Francis Hookham]

I have found a macro to convert a list of names which are in to but I need
one to covert to 'Proper Case' since it is necessary to maintain the capital
first letter of each word

In anticipation - thanks once again

Francis Hookham

 

[JE McGimpsey]

I have found a macro to convert a list of names which are in to but I need
one to covert to 'Proper Case' since it is necessary to maintain the capital
first letter of each word

See David McRitchie's site:

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

 

[nathan.oliver]

Hello,

since it is necessary to maintain the capital first letter of each word

Proper or Sentence case?

Also, see the following:

http://www.mrexcel.com/board2/viewtopic.php?p=901966#901966

Regards,
Nate Oliver