Search results 185

Sorted from new to old.

WordsOf + Words_Len

WordsOf to create list of words from a block after converting every special ...

2018Jun28

NMACode

Converts all Æ¼ found in a string into their actual chars

2018Jun27

TextPercentageMatch

Matching any part of a string in another , then returns 0 if not match, Or ...

2018Jun26

RemoveChars

Removes all chars found in Chars_to_remove from String1

2018Jun22

File_FirstFound

Gets first file found matches a wildcards mask, using Dir()

2018Jun20

HaveNonEnglish + StringASCIIs

Checks if one char is within two ASCII codes or not (StringASCIIs) Used to see ...

2018Jun17

MatchIf_ThenDelete

Searches for an item in a column, then if found, delete that cell (not clear, ...

2018Jun17

Match4

Matching 4 values at the same time in 4 columns Just like Match the function, ...

2018Jun16

MatchIf (aka VMatchIf)

The best Match I created, return 0 if not found, kind of CountIF+Match ...

2018Jun16

Col2Combo

Reads everything in a column (starting from certain cell until blank cell is ...

2018Jun10

FindName

Finds a name in a workbook, returns true or false

2018Jun10

Modify SQL table

SQL seams to have issues when we try to modify a table and preserving data, I ...

2018Jun9

Frequency

Checks how many items in an ANStr ANStr is list of items separated by a ...

2018Jun8

FindSheet

Finds a sheet in a workbook, if no workbook name passed, it will use ...

2018Jun7

FindIn1DArray

Returns 1 if an item found in array, 0 if not

2018Jun6

CutRightString

Cuts a string from a string FROM RIGHT starting from specific character and ...

2018Jun2

1 2 ...11 12