{"id":1444,"date":"2012-09-11T14:24:36","date_gmt":"2012-09-11T14:24:36","guid":{"rendered":"http:\/\/galhano.com\/blog\/?p=1444"},"modified":"2012-09-11T14:25:15","modified_gmt":"2012-09-11T14:25:15","slug":"excel-how-to-make-first-character-uppercase-the-rest-lowercase","status":"publish","type":"post","link":"http:\/\/galhano.com\/blog\/?p=1444","title":{"rendered":"Excel – How to make first character Uppercase, the rest lowercase?"},"content":{"rendered":"

make a quick test file
\nsee what this is going to do. if its what you want, then try it in your original<\/p>\n

– Right Click on your sheet1 tab and choose View code (or just hit Alt F11)
\n– cut and paste this<\/p>\n

[vb]<\/p>\n

Sub SentenceCase()
\n For Each cell In Selection.Cells
\n s = cell.Value
\n Start = True
\n For i = 1 To Len(s)
\n ch = Mid(s, i, 1)
\n Select Case ch
\n Case "."
\n Start = True
\n Case "?"
\n Start = True
\n Case "a" To "z"
\n If Start Then ch = UCase(ch): Start = False
\n Case "A" To "Z"
\n If Start Then Start = False Else ch = LCase(ch)
\n End Select
\n Mid(s, i, 1) = ch
\n Next
\n cell.Value = s
\n Next
\n End Sub<\/p>\n

[\/vb]<\/p>\n

– then highlight your column (or whatever you want to change)
\n– then run the macro
\n– click tools
\n– click macro
\n– choose sentance case and run<\/p>\n","protected":false},"excerpt":{"rendered":"

make a quick test file see what this is going to do. if its what you want, then try it in your original – Right Click on your sheet1 tab and choose View code (or just hit Alt F11) – cut and paste this [vb] Sub SentenceCase() For Each cell In Selection.Cells s = cell.Value […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"close","ping_status":"close","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[148],"class_list":["post-1444","post","type-post","status-publish","format-standard","hentry","category-truques-dicas","tag-excel","author-admin"],"_links":{"self":[{"href":"http:\/\/galhano.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/1444","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/galhano.com\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/galhano.com\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/galhano.com\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/galhano.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1444"}],"version-history":[{"count":3,"href":"http:\/\/galhano.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/1444\/revisions"}],"predecessor-version":[{"id":1447,"href":"http:\/\/galhano.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/1444\/revisions\/1447"}],"wp:attachment":[{"href":"http:\/\/galhano.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1444"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/galhano.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1444"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/galhano.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1444"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}