Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 146
  • Last Modified:

Upper and Lower case Function

Does anyone know if there is a Function that I can use to change only the firstname's, middlename's and lastname's letters in a name, example :

paul peter smith to Paul Peter Smith

Thanks
0
tomcruisew
Asked:
tomcruisew
1 Solution
 
Erick37Commented:
use:

sName = StrConv(sName, vbProperCase)
0

Featured Post

Ask an Anonymous Question!

Don't feel intimidated by what you don't know. Ask your question anonymously. It's easy! Learn more and upgrade.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now