change case function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I thought there was a function that would let me case the case of a text
string to 'proper case' ...that would capitalize the first letter of each
word. I want to run a macro to change my contact names to this, right now
some have the last name all capitalized.
does anyone know how to do this?
thanks,
ck
 
I thought there was a function that would let me case the case of a text
string to 'proper case' ...that would capitalize the first letter of each
word. I want to run a macro to change my contact names to this, right now
some have the last name all capitalized.
does anyone know how to do this?
Click to expand...

Doesn't StrConv(strText,vbProperCase) do most of what you want? You'll
have to deal with special cases like "O'Brian", "McDonalds", "de la
Rossa", "von Braun" yourself.
 
Back
Top