Search results 95

Sorted from new to old.

ExtractNumeric_FromCell

Returns the number from an HTML cell after cleaning and finding sign. We faced ...

Aug6

ANmaReplace_Occurrence

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

Jul13

ANmaSearch_AmpFriends

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

Jul7

SwitchTextinCells

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

Feb23

Free online tools - convertcase.net

Bunch of online some text and image tools, helpful for most online users these ...

Feb15

HTML_CleanNumber

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

Jan31

Frequency1

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

2023Dec16

SQL Date from DateTime

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

2023Nov29

ReplaceStrings

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

2023Nov11

Column1Range

Return a range of cells in column where ... Return Range Ignore header ...

2023Oct7

IfFullWord

Returns True if found as full, False if not found as full Full word means word ...

2023Jul24

Refresh Table from View

Convert SQL View into table for speed reading. Using views a lot, I needed a ...

2023Jul19

SubZero

Forces Excel to not convert numbers during moving them across sheets, or ...

2023May23

GetAmazonPrice

Reading price of an item in Amazon. An AI-generated function with AI-generated ...

2023Apr3

Filename_Clean

Returns cleaned file name of invalid characters. Needs to be modified if used ...

2023Jan11

MultiTrim

Trims leading and trailing tabs, spaces and Enters Code has lines to work in ...

2022Dec3

1 2 ...5 6