Codes Required
CutString_ReverseFrom
Returns full string starting from the point of LocIndex minus back where we ...
Feb27
CutString8
Cuts a string from certain character to certain character with option of either ...
2021May29
CutString_Words_Left + CutString_Words_Mid
Cuts the left or Middle part of string without breaking words Can specify ...
2018Aug8
CutString1
Cuts a string from a string starting from a specific character index and until ...
2018Jul11
CutString3_Search
Using same code in CutString3, this will search for matching items. Searches ...
2018May29
Similar codes
UTF8R_toChar
Converts characters created by program R into actual chars as in < U+641 > to ...
2018Jun26
Morse code functions
Convert text or single character to and from Morse code. TexttoMorse, ...
2021Jun13
URL2Text + Text2URL
URL2Text to convert a URL into string Text2URL will converts a text with ...
2018Apr15
ReplaceChars
Replaces all chars found in Chars_to_remove from String1 with Char_to_put One ...
2018May26
HaveNonEnglish + StringASCIIs
Checks if one char is within two ASCII codes or not (StringASCIIs) Used to see ...
2018Jun17
OpenPassword + ClosePassword
Encrypt / Decrypt a string, convert it to "77 96 105 105 106" or back to ...
2018Jun14
Recently by developer
ANString_Location
Finds the location of a sting inside list of strings with certain separator, or ...
Tue 8AM
SettingSave + SettingRead for NumberFormat
Reads or applies certain NumberFormat to cell in settings. Same patterns as ...
Apr19
ANmaCellFormat
Reads or set Numberformatting for a cell or range. Can pass sheet and workbook ...
Apr18
CopyFields_FromTo
Moves strings within cells into other cells, move or copy. Specific task to ...
Apr17
Random Codes
CopyDynamicRangeValue
Copy values from range to cell. Without using clipboard of course. Here the ...
Aug10
GetColumnIndex
Returns Id of column (Column Index) from a cell. Similar to GetColumnName, this ...
2021Nov26
HTMLTagAttributeValue
Reads value of certain tag attribute from certain attribute Identify attribute ...
2021May30
MinIF and MaxIF in Excel 2010
MinIF to calculate smallest number matching certain criteria, in Excel 2010 ...
2019Feb1