VBA check if first letter is capital

[Dimitris254]

Hi all,

I would like to go through a column with names and check if the first letter is capital (English characters/alphabet used in the worksheet).

I've found this thread, but i think it's only for 1 string (i want to go through all cells in column B).


Thank you in advance

 

[Dimitris254]

Something else to consider if the values are being entered manually is to try to force the correct entry in the first place with a Data Validation custom formula applied to column B

=EXACT(B1,PROPER(B1))

thank you for the info, unfortunately i'm not the owner of the document - but i have to fix it before using it...

i'll keep this in mind though for my docs

 

[Peter_SSs]

thank you for the info, unfortunately i'm not the owner of the document - but i have to fix it before using it...

OK, fair enough. It was just a thought.

 

[Dimitris254]

Might as well throw this in too

Sub t()
Dim c As Range
    With ActiveSheet
        For Each c In .Range("B2", .Cells(Rows.Count, 2).End(xlUp))
            txt = StrConv(c.Text, vbProperCase)
            c.Value = txt
        Next
    End With
End Sub

after testing this a little more, i noticed that it the Proper function will decapitalise (as it should) some names, e.g. Peter-Georg will turn into Peter-georg

which i wonder why is the reason, since Rick is also using Proper

 

[Peter_SSs]

after testing this a little more, i noticed that it the Proper function will decapitalise (as it should) some names, e.g. Peter-Georg will turn into Peter-georg

which i wonder why is the reason, since Rick is also using Proper

StrConv( ,vbProperCase) and the worksheet function PROPER() do not behave exactly the same. You have found an example of that fact.

 

[footoo]

StrConv( ,vbProperCase) and the worksheet function PROPER() do not behave exactly the same. You have found an example of that fact.

This is quite a widely discussed topic in Excel discussion sites
(e.g. http://answers.microsoft.com/en-us/...itle-udf/b91ae9d1-7d56-4503-81fa-9593e7358640)

vbProperCase will convert names such as O'Malley to O'malley
Both vbProperCase and PROPER will convert names like McNab and IBM to Mcnab and Ibm