Search results 202

Sorted from new to old.
Card image
NumberNumberNumber

Finds 3 numbers in a string by ignoring characters between them. ' example ...

Card image
VBInstr_Numeric

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

Card image
CutString11

Cuts long string from certain character to certain character with option to ...

Card image
SwitchTextinCells

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

Card image
Send workbook as email attachment

Retro way to send a workbook you are in as an email. Found it in one of my old ...

Card image
gsplit usage

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

Card image
HTML_CleanNumber

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

Card image
VLookup_HTML

Does a search in 1st column (< td tag) in an HTML table (< table tag), and ...

Card image
RangeValues

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

Card image
PivotTable_ShowHideItems

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

Card image
PivotTable_ShowHideBlankItems

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

Card image
UnUnixDateTime

Convert a number represents a date in Unix format back into date, opposite of ...

Card image
CutLeftNumber

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

Card image
ChartLabelsNumberFormat

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

Card image
ANmaPivotTable_Clear

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

Card image
ChartLegendCenter

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