VBA-Excel 60

Sorted from new to old.

MathInsideText

Return string after applying math to each number found inside the string. ...

May8

String_Fx

Generate repeated text, like String() the function but with ability to repeat ...

Apr10

String_S

Generate repeated text, like String() the function but with ability to repeat ...

Apr10

CutString_ANmaRules

Extract certain text from another text based on Rules defined, like extracting ...

Feb26

ANmaSearch_AllWords_FromANStr

Checks if string has all words from ANStr inside Retuns 0 if not found or ...

Jan8

VBInstr_Occurance

Returns location of text inside another with jump ability for any certain ...

2024Dec1

QuickEncrypt plus others ...

Text encryption/decryption snippet that utilizes the powerful xICE encryption ...

2024Aug15

CountNumbers_inString

Returns how many numbers found inside a text

2024Aug1

Quarter1stLastDate_FromQuarterText

Returns the date of 1st day or last day in a Quarter Mar 31st, Jun 30th, Sep ...

2024Jul26

RemoveSignWord

Removes the WordTemplate [Sign-Head-????] from FromStr and returns whatever ...

2024Jul15

ANmaReplace_Occurrence

Replaces certain occurrence of a string with another inside a string. Like ...

2024Jul13

ANStr_RemoveDuplicates

Removes duplication in ANStr separated by a separator.

2024Jul13

ANmaSearch_AposFriends

Searches for string inside string with apostrophe possibility (or as I call ...

2024Jul11

ReturnLongestString_Of2

Returns the string that is longer, comparing what is before StrSepa versus ...

2024Jul2

CalculateQuarterText

Returns the text of quarter (3Q2024 or 1Q2017) with offset of the passed ...

2024Jun10

ANmaSearch_ApostropheFriends

Searches for string inside string with apostrophe variations conversion

2024May27

1 2 3 4