Ne postoji takva f-ja.
Pogledaj primere C.Pearsona ovde:
Changing Text Case
Inače, lako ćeš rešiti formulama ako je samo do prvog slova:
Code:
=UPPER(LEFT(A1,1)) & RIGHT(A1,LEN(A1)-1)
Problem je zapravo složeniji jer bi f-ja morala da prepoznaje početak rečenice, što je već posao za korisničku f-ju.
Najelegantnije rešenje koje sam našao:
Code:
Function Sentence(ByVal txt As String) As String
Dim m As Object
txt = LCase(txt)
txt = Application.Replace(txt, 1, 1, UCase(Left$(txt, 1)))
With CreateObject("VBScript.RegExp")
.Pattern = "\.\s."
.Global = True
For Each m In .Execute(txt)
txt = Application.Replace(txt, m.FirstIndex + 1, m.Length, UCase(m.Value))
Next
End With
Sentence = txt
End Function
preuzeto sa
Capitalize First Letter Of Each Sentence
Have you found helpful examples, solutions or ideas-in-work, please consider the
following:
• Citation of *actual page* you are going to using is welcome.
• Have you saw "Value Added" examples you are going to incorporate to your
profitable blog, daily job or any money making venture: How about online donation?
↗Ana & Vlade Divac Foundation
Hvala!