Search results 328

Sorted from new to old.

ANmArray_1stMatch_orPartial

Returns the 1st item found in array matching partially the search for value. ...

Aug14

ANmaTable_FieldValue_Concat

Concatenates fields in certain row each with its header and returns the full ...

Jul26

ANmExcel_Replace

Replace text in cell using Excel built-in Replace function. Ability to do ...

Jul10

DuplicatedList

Returns list of duplicated items in a range as ... ' ...

Jun21

CutString_Area

Returns full area found in ThePage between Between_Char1 and and_Char2 that ...

Jun1

ANmaTableAddress

Returns the full name of table with its sheet name to be used in formulas or in ...

Apr26

FormatNumbers_InsideText

Formats all numbers found inside text to certain format. Excluding numbers ...

Mar9

ANStrColor2RGBA_Para

Returns Red, Green, Blue and Transparency from text representing color Like ...

2025Dec20

Variable_PerLocation_FromFullLine

Extract set from ANstring, like 2nd set of variable list using specific ...

2025Oct16

Shapes_HideShow

Hides or shows multiple shapes in a sheet in Excel, using one line command ...

2025Sep30

JSon_Read_aText

Reads all json files generated by aText Sync command (screenshots) from certain ...

2025Jul27

QTexts_Min

Returns minimum quarter of 2 strings representing quarters, like 1Q2024, 3Q2015, ...

2025Jul27

CutString_JsonKeyValue

Reads value from json string for certain key. Using RegEx Regular Expression. ...

2025Jul27

UnicodeToChrW

Converts a Unicode number into its ChrW text. It automatically uses surrogate ...

2025Jul17

ANStrVLookupAll

Retuns list of all matchings after doing vlookups to return item from 2-dim ...

2025Jun14

ANStrVLookup

behaves as vlookup to return item from 2-dim ANStr Can choose which column, ...

2025Jun14

1 2 ...20 21