Search results 59

Sorted from new to old.

ANmArray_1stMatch_orPartial

Returns the 1st item found in array matching partially the search for value. ...

Aug14

ANmExcel_Replace

Replace text in cell using Excel built-in Replace function. Ability to do ...

Jul10

Str2Clean

Cleans string. Just another function to clean string from unwanted characters

2025May22

ANmaNotMatch

Finds first item from RngAddr that is not listed in InRngAddr Returns the item ...

2025Apr19

FirstDuplicatedItem

Returns the value of first duplicated item found in a range. This is to ...

2025Apr18

TemplateLine_10Xs

Two functions to automate the replacing of variables inside a long string. Up ...

2025Mar16

HTMLTable_FindTable

Reads < table .... < /table> found after index Have ability to opnly bring the ...

2025Jan12

VBInstr_Any

Returns the index where any of the words from AnStrSearchFor found in SearchIn ...

2024Nov17

ANmaSearch_SpaceFriends and LeftSpaceFriends

Searches for string inside string covering multiple possibilities for space ...

2024Jul30

ANmaReplace_Occurrence

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

2024Jul13

ANmaSearch_AmpFriends

Searches for string inside string with multiple possibilities if the char & ...

2024Jul7

ANmaSearch_ApostropheFriends

Searches for string inside string with apostrophe variations conversion

2024May27

CopyFiles Excel-Macro

Simple macro to make sure we have a copy of all files in a folder found in ...

2024Mar12

SwitchTextinCells

Switch text inside cells with another text. This was needed to correct an bug ...

2024Feb23

VBInstrRev

Similar to VBInstr, but this one does it in reverse, which is instrrev() ...

2024Jan24

Frequency1

Finds how many a string found inside larger string. Similar to Frequency but ...

2023Dec16

1 2 3 4