Search results 421

Sorted from new to old.

ANString_Location

Finds the location of a sting inside list of strings with certain separator, or ...

2024Apr23

SettingSave + SettingRead for NumberFormat

Reads or applies certain NumberFormat to cell in settings. Same patterns as ...

2024Apr19

CopyFields_FromTo

Moves strings within cells into other cells, move or copy. Specific task to ...

2024Apr17

Between2int and Between2intinc

Checks if number between two numbers, with or without considering those numbers. ...

2024Mar23

Concatenate_HTMLColumn

Build a string from a certain column in html table (using < table, < tr, and < ...

2024Mar14

Just learnt that now

Looks like we cannot have filename (having no extension) and folder in same ...

2024Mar5

FindAncherURL_InHTMLRow

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

2024Mar4

DateDateDate

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

2024Mar3

NumberNumberNumber

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

2024Mar2

HTML_InsideTag_ByIndex

Checks if LocIndex is found between open and close of HTMLTag or between close ...

2024Feb28

VBInstr_Numeric

Finds location of 1st numeric character inside string starting from a certain ...

2024Feb25

CutString11

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

2024Feb24

SwitchTextinCells

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

2024Feb23

UniqueRandomID in SQL

Generate new Random ID, unique not duplicated in two columns in two tables. ...

2024Feb18

FindLinks xla

Excel Addon to find links in workbook. FindLinks v13.2 From

2024Feb9

Install/Uninstall SQLNativeClient DB driver

Install/Uninstall SQL DB driver. SQLNCLI.msi that is needed when you do ...

2024Feb8

1 2 ...5 ...26 27