Search results 424

Sorted from new to old.

FindAncherURL_InHTMLRow

Finds the URL (href tag value) for an anchor inside a table row (tr element) ...

Mar4

DateDateDate

Finds three dates after each other in one paragraph. Needed to locate numbers ...

Mar3

NumberNumberNumber

Finds 3 numbers in a string by ignoring characters between them. ' example ...

Mar2

EdgarCIK

Search for company long name in Edgar and returns its CIK Using SEC.gov site ...

Feb25

CutString11

Cuts long string from certain character to certain character with option to ...

Feb24

ANStrSort3

Sort list of texts having cell address by cell address as alphanumeric in Asc ...

Feb20

Free online tools - convertcase.net

Bunch of online some text and image tools, helpful for most online users these ...

Feb15

Send workbook as email attachment

Retro way to send a workbook you are in as an email. Found it in one of my old ...

Feb14

Win10 ThisPC Virtual locations

I hate it when Windows forcing us to have additional items in "This PC" So, I ...

Feb5

SQL instr

Searching for a string inside a string in SQL. You may say it is the instr in ...

Feb3

Random Number in SQL

Generate Random number inside SQL using timestamp (GetDate function) One of ...

Jan30

VLookup_HTML

Does a search in 1st column (< td tag) in an HTML table (< table tag), and ...

Jan26

VBInstrRev

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

Jan24

PivotTable_ShowHideItems

Show or hide item (or items) in PivotTable for a certain field. Passing ...

Jan23

PivotTable_ShowHideBlankItems

Shows or hides an item or items in a PivotTable filter field. Passing ...

Jan22

SQL Cross Apply String_Split with XML Path

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

Jan20

1 2 3 ...26 27