PCase (ProperCase)

Just like UCase and LCase, ProperCase (or PCase) will capitalize 1st letter of each word

Function PCase(String1)
PCase=StrConv(String1, vbProperCase)
End Function
Function ProperCase(String1)
ProperCase=StrConv(String1, vbProperCase)
End Function

String1

Views 733 Downloads 316

'Case', 'string', 'lcase', 'ucase', 'pcase', 'proper', 'propercase', 'convert', 'replace', 'change'

ANmarAmdeen
333
Texts + Strings VBA
Revisions

v2.0