Search results 88

Sorted from new to old.

ANmAddress_Dimensions

Detects how many dimensions an address has, This is what I call it dimensions ...

2024Nov8

ANmAddress_Value

Returns the value of a cell address in another sheet. Todo: Allow to reference ...

2024Oct31

ANmAddressSame

Checks if passed addresses are referring to same cell regardless of ...

2024Sep24

ANmAddressRefStyle

Returns type of the cell address, A1 or R1C1 If multiple cells passed, the ...

2024Sep23

ANmaFiles2List

Generating list of files in a folder. One file to do that. I know this has ...

2024Sep21

ANmaRead_1stFile

Returns information about first file name found after sorting matching files in ...

2024Aug11

ANmaCellChar_Superscript_Subscript

Sets certain character inside a cell as superscript or subscript

2024Aug11

ANmaSearch_SpaceFriends and LeftSpaceFriends

Searches for string inside string covering multiple possibilities for space ...

2024Jul30

ANmaSearch_OrFriends

Search for one of items in SearchFor_ListOfFriends inside SearchIn and return ...

2024Jul30

ANmaSpecialFolders

Returns path for a specific special folder in system Passing the name of that ...

2024Jul26

ANmaSearch_QuoteFriends

Searches for string inside string with double-quote possibility If single ...

2024Jul13

ANmaReplace_Occurrence

Replaces certain occurrence of a string with another inside a string. Like ...

2024Jul13

ANStr_RemoveDuplicates

Removes duplication in ANStr separated by a separator.

2024Jul13

ANmaSearch_AposFriends

Searches for string inside string with apostrophe possibility (or as I call ...

2024Jul11

ANmaSearch_AmpFriends

Searches for string inside string with multiple possibilities if the char & ...

2024Jul7

ANmAdd_ThenSort_2Columns

Adds values of 2 cells into 2 columns (usually below them). I used these small ...

2024Jun1

1 2 ...5 6