Search results 34

Sorted from new to old.

Formulas_FromFile_ToRow

Imports formulas from file into list of cells defined in file itself into ...

Oct11

FirstDuplicatedItem

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

Apr18

ANmaFiles2List

Generating list of files in a folder. One file to do that. I know this has ...

2024Sep21

FixURL

Return safe URL after converting critical chars to whatever passed in SafeChar

2024Sep16

ANmaSearch_QuoteFriends

Searches for string inside string with double-quote possibility If single ...

2024Jul13

ANmaSearch_AposFriends

Searches for string inside string with apostrophe possibility (or as I call ...

2024Jul11

ANmaSearch_ApostropheFriends

Searches for string inside string with apostrophe variations conversion

2024May27

SwitchTextinCells

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

2024Feb23

gsplit usage

How to use gsplit to split large files into smaller parts to allow to read it. ...

2024Feb7

ConcatenateStrings_AmongString

Collect strings matching search from a longer string. I used it to concatenate ...

2024Jan17

HTMLPaddingMargin_v2

Finds the padding or margin from a style statement for an HTML tag. Passing ...

2024Jan5

Associate_Ext

2023Nov25

ContainerHTMLTag

Returns HTML tag of the container of certain location inside HTML block. ...

2023Oct21

SubZero

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

2023May23

ANmaInt

Cuts the integer part of a number. Like INT, FIX, or CINT I know we already ...

2023May2

Filename_Clean

Returns cleaned file name of invalid characters. Needs to be modified if used ...

2023Jan11

1 2 3