Essential Excel Add-In Activity
Brought to you by:
stevetowner
Activity for Essential Excel Add-In
-
Essential Excel Add-In released /Essential Excel Add-In/1.44.0/Essential_Excel_Add-In_Setup_v1.44.0.exe
-
-
Boban_Spasic created ticket #3
Another version of Clean Text
-
-
-
-
-
epicode posted a comment on ticket #2
Sure.
-
SteveT posted a comment on ticket #2
Thanks. I have incorporated your two requests. I don't know when I will release a new version, but if you want to try this out, I can send you an advance copy. Steve On Tuesday, July 11, 2023 at 03:20:42 PM CDT, M MOHSIN mohsyn@users.sourceforge.net wrote: [feature-requests:#2] Regex Find and Replace (Not as formula) Status: open Group: Next_Release_(example) Created: Tue Jul 11, 2023 08:20 PM UTC by M MOHSIN Last Updated: Tue Jul 11, 2023 08:20 PM UTC Owner: nobody I use regex to search and replace...
-
Regex Find and Replace (Not as formula)
-
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.
-
-
-
-
-
T McGuff posted a comment on discussion Help
Thanks Steve! I'm looking forward to using it again.
-
v1.39.0 is the first release that should run on Excel x64. There were many changes needed and I tested as best I can, but I would not be surprised if there are still some bugs to fix.
-
v1.39.0 is the first release that should run on Excel x64. There were many changes needed and I tested as best I can, but I would not be surprised if there are still some bugs to fix.
-
v1.39.0 is the first release that should run on Excel x64. There were many changes needed and I tested as best I can, but I would not be surprised if there are still some bugs to fix.
-
v1.39.0 is the first release that should run on Excel x64. There were many changes needed and I tested as best I can, but I would not be surprised if there are still some bugs to fix.
-
v1.39.0 is the first release that should run on Excel x64. There were many changes needed and I tested as best I can, but I would not be surprised if there are still some bugs to fix.
-
-
-
Thanks. The issue occurs when a single cell is selected and some part of the worksheet is hidden (like columns are hidden). In this case, the function SpecialCells returns all cells instead of the correct range. This appears to be a bug/feature of Excel, depending on how you interpret the implementation. In any case, I consider it a bug, so I am adding some additional code to detect and workaround it. Meantime, understand the workaround is to select more than one cell if any area is hidden. Thanks,...
-
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.
-
You can add attachments to a message here.
-
Great! Thanks for your work. It's an excellent add-in!
-
I can share a dummy excel file which reproduces this behavior. let me know email id.