Search results 11

Sorted from new to old.
Card image
ConditionalFormatting_ColorARow

Adds conditional formatting to color a row in table based on output of formula ...

Card image
HTMLCloseTag_HasWordAfter

Finds the number of occurrence of a "Numeric" inside a string having a certain ...

Card image
ANmaReplace_Occurrence

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

Card image
SQL Cross Apply String_Split with XML Path

SQL select statement to convert list of IDs found in column (from more than row ...

Card image
CutString7

Cuts right part of a string starting from certain occurrence of a separator ...

Card image
ANmaVLookup

Finds first occurrence of item in column, then returns value from same row as ...

Card image
Excel 2010 hyperlink issue fix

An issue I started to see when clicking on a hyperlink in Excel 2010, while I ...

Card image
MatchLastIf

Finds last occurrence of a match in a column Finds the row of last time an ...

Card image
Unprotect sheet or workbook

Unprotect worksheet (and workbook) using VBA code

Card image
doHighlight

Search for occurrences of a keyword in a string and highlight them, by either ...

Card image
ProtectText + UnProtectText

Encrypt or decrypt text, simple encryption with a numeric password Decrypt a ...