• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 149
  • 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

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