Activity for epicode
-
epicode posted a review on Structure Synth
-
-
Sure.
-
Regex Find and Replace (Not as formula)
-
Error while executing
-
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),...
-
-
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),...
-
-
When using "Capitalize each word" it recognizes apostrophe and minus as end of the word and capitalizes every letter after them like Tom'S Can there either be an exception for apostrophe and minus symbol by default since they are not end of word or at least an option to exclude them?
-
Change every word to Capital incorrectly recognizes apostrophe as and of word and capitalizes every letter after apostrophe like Tom'S Can there either be an exception for apostrophe and minus symbol by default since they are not end of word or at least an option to exclude them.
-
-
Select only one cell and change case to anything - it will affect all the other cells works normally if two or more cells are selected.
-
I can share a dummy excel file which reproduces this behavior. let me know email id.
-
Yes I can reproduce the issue in a specific file.
-
-
-
I recently used change case feature and to my horror it 1. did not warn 2. changed case for whole sheet instead of selection 3. no way to undo 4. no backup of sheet I hope you rectify Change Case Tool issue to prevent Data Loss!
-
I recently used change case feature and to my horror it 1. did not warn 2. changed case for whole sheet instead of selection 3. no way to undo 4. no backup of sheet this is a nightmare of a tool. I hope you rectify it!!!!
1