excel – Capitalise first letter of words without changing currently Capitalised

excel – Capitalise first letter of words without changing currently Capitalised

Here is a VBA way, add it to a module & =PrefixCaps(A1)

Public Function PrefixCaps(value As String) As String
    Dim Words() As String: Words = Split(value,  )
    Dim i As Long
    For i = 0 To UBound(Words)
        Mid$(Words(i), 1, 1) = UCase$(Mid$(Words(i), 1, 1))
    Next
    PrefixCaps = Join(Words,  )
End Function

Used the website http://www.textfixer.com/tools/capitalize-sentences.php and pasted it all in instead

excel – Capitalise first letter of words without changing currently Capitalised

That was all a bit complicated, but I did find if your spreadsheet is pretty simple, you can copy and paste it into word and use its editing features and then copy and paste that back in to Excel. Worked quite well for me.

Leave a Reply

Your email address will not be published.