Search results 20

Sorted from new to old.

UnicodeToChrW

Converts a Unicode number into its ChrW text. It automatically uses surrogate ...

2025Jul17

Str2Clean

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

2025May22

VBInstr_Occurance

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

2024Dec1

ANmaRemoveBlanks_1Col

Remove blank cells from 1 column

2024Nov17

JSon functions to add, read and delete entry

3 Json functions to read full node by an image, add full node to file or delete ...

2024Oct29

ANmaRemoveNestedTags

Remove tags that are identical and nested inside each other in an HTML document, ...

2024Feb4

VBInstrRev

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

2024Jan24

PivotTable_ShowHideBlankItems

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

2024Jan22

Grandchildren files and count

Returns list of files in 2 level folders Will not find files as children of ...

2024Jan11

SubZero

Forces Excel to not convert numbers during moving them across sheets, or ...

2023May23

ReadLastChars

Reads last some characters of a file, needs to see contents of large files that ...

2023Apr20

ArrSort_4Arr

Sort 4 1-dimension arrays Actually sort 1st array (arrShort) based on values ...

2023Apr14

DiskDriveType

Returns drive type as text, like fixed, CD, etc. Can pass either drive letter, ...

2022Aug17

DynamicFill

Fills in more rows at end of a range Used to add more rows at end to have all ...

2022Mar11

NMRRank_v2021

Ranks a number among set of numbers. This is part of huge tool, we needed to ...

2021Sep23

merge2Arrays

Merges two 1-dimension arrays and return an array Both should be 1 dimensional ...

2021Sep21

1 2