Saturday, March 08, 2008
Testing a String for Proper Case
Have you ever needed to check a string in a worksheet cell to see if it is in proper case? By "proper case" I mean that the first letter of each word in the string is capitalized and the other characters are lowercase. For example, you may have a list of people’s names (maybe for a mailing list) and you need to be sure that the names are written properly (e.g., John Smith, not john Smith or John sMith). It seems that this should be easy in Excel, but it isn’t obvious (at least there is no easy, built-in function that you can use to validate the string). In this post I will demonstrate three
Posted by Tim on 03/08 at 07:28 PM in
Array Formulas
in
Functions
in
Offset
in
String Functions
in
Code
in
left
in
len
in
mid
in
Proper
in
VBA
Comments (1) • Permalink • Tell-a-Friend
Comments (1) • Permalink • Tell-a-Friend
Page 1 of 1 pages
