Search results 151

Sorted from new to old.

RangeValues

Returns values of all cells in range into 1 string Only non-blank values ...

2024Jan25

PivotTable_ShowHideBlankItems

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

2024Jan22

SQL Cross Apply String_Split with XML Path

SQL select statement to convert list of IDs found in column (from more than row ...

2024Jan20

ImgDimensions

Reads image dimensions, width, height, depth and image type. Details returned ...

2024Jan16

CutString9

Cuts from CutFrom starting from any of items found from ...

2024Jan7

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

Frequency1

Finds how many a string found inside larger string. Similar to Frequency but ...

2023Dec16

Between_2Chars

Returns if a char was found between two defined characters. Like find if Loss ...

2023Nov22

HTML2Str

Special version to convert HTML to string. Uses RemoveHTML, then after that it ...

2023Nov5

HMatchIf_Multi

Returns column if an item from list of items was found in a row. Similar to ...

2023Oct30

NumberFoundinsideTag

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

2023Aug21

IfFoundInList

Checks to see if sStr matches on of the items in Listof, knowing separator, ...

2023Jul24

Between_HTMLtag

Returns the full text found between HTML tag open and close by either and index ...

2023Jul22

WordPress - Excel functions (AI)

3 functions to download posts, adds new post and to upload and set featured ...

2023Apr22

ReadLastChars

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

2023Apr20

1 2 3 ...9 10