Search results 60

Sorted from new to old.

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

CutString_ReverseFrom

Returns full string starting from the point of LocIndex minus back where we ...

2024Feb27

VBInstr_Numeric

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

2024Feb25

HTML_CleanNumber

Cleans block of string (HTML block) from characters that are not needed Can ...

2024Jan31

VBInstrRev

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

2024Jan24

CutString7

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

2024Jan1

CutLeftNumber

Cuts the left part of string as long as it is number Keeps getting characters ...

2023Dec31

ANmaNumber_Closest2Word

Finds the number between two spaces that is found close to of Word1Location ...

2023Oct24

BusinessDateAdd

Counts the number of business days Add or subtract a number of business days ...

2023Oct11

NumberFoundinsideTag

Checks if a number found between two characters, searching can be customized to ...

2023Aug21

LXFormat

Formats a number found at end of string to have additional leading zeros to ...

2023Jun30

SubZero

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

2023May23

NumberEnding

Add st, nd, rd or th to end of number, can be used for dates also

2023May3

ReadBinaryBuffer

Reads file in binary mode as blocks Starts reading from start in sequential ...

2023Apr30

SwapNumbers

Swap two numbers variables without using third variable A trick worth saving ...

2022Oct17

1 2 3 4