User Activity
- Posted a review on Structure Synth
- Posted a review on Regex Find & Replace in Excel
-
Posted
a comment
on
ticket #2
on
Essential Excel Add-In
Sure.
-
Created
ticket #2
on
Essential Excel Add-In
Regex Find and Replace (Not as formula)
-
Created
ticket #5
on
Regex Creator
Error while executing
-
Modified
a comment
on
discussion Help
on
Essential Excel Add-In
I realized that this is not a problem of Essential Addin but default behaviour of Proper Function in Excel which does not respect ' and - I am using the following code to bypass the issue (sharing here for anyone with same issue or for Steve to include as part of Essential ) Public Function ProperCase(ByVal str As String) As String Dim words As Variant Dim i As Long Dim word As String words = Split(str, " ", , vbTextCompare) For i = 0 To UBound(words) words(i) = UCase(Left(words(i), 1)) & LCase(Mid(words(i),...
- Modified a comment on discussion Help on Essential Excel Add-In
-
Posted
a comment
on
discussion Help
on
Essential Excel Add-In
I realized that this is not a problem of Essential Addin but default behaviour of Proper Function in Excel which does not respect ' and - I am using the following code to bypass the issue (sharing here for anyone with same issue or for Steve to include as part of Essential ) Public Function ProperCase(ByVal str As String) As String Dim words As Variant Dim i As Long Dim word As String words = Split(str, " ", , vbTextCompare) For i = 0 To UBound(words) - 1 words(i) = UCase(Left(words(i), 1)) & LCase(Mid(words(i),...
Personal Data
- Username:
- mohsyn
- Joined:
- 2022-03-07 07:02:31.148000
Projects
- No projects to display.