Search results 115

Sorted from new to old.

PivotTable_ShowHideItems

Show or hide item (or items) in PivotTable for a certain field. Passing ...

Jan23

SQL Cross Apply String_Split with XML Path

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

Jan20

Converts two bytes to long

Functions to convert two bytes to a numeric value (long), (both little-endian ...

Jan14

CutLeftNumber

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

2023Dec31

ChartLabelsNumberFormat

Apply Number format of 1 decimal to datalabels of specific series in certain ...

2023Dec23

ANmaPivotTable_Clear

Clears all filters in PivotTable and hide the [blank] item from list, pass ...

2023Dec22

ChartLegendCenter

Put chart legend at center of chart horizontally. Changes left and width only. ...

2023Dec21

Macro keyboard shortcuts

Assign certain keyboard shortcut to certain macro, or clear that shortcut. ...

2023Dec13

SQL Date from DateTime

Extract Date from Datetime field in SQL An old method I found in my archive.

2023Nov29

Between_2Chars

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

2023Nov22

ReplaceStrings

Replace strings found in list of strings from inside a string, does that make ...

2023Nov11

HTML2Str

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

2023Nov5

NumberFoundinsideTag

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

2023Aug21

Between_HTMLtag

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

2023Jul22

LXFormat

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

2023Jun30

ReadLastChars

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

2023Apr20

1 2 ...7 8