Search results 65

Sorted from new to old.

ANmExcel_Replace

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

Jul10

Str2Clean

Cleans string. Just another function to clean string from unwanted characters

2025May22

TemplateLine_10Xs

Two functions to automate the replacing of variables inside a long string. Up ...

2025Mar16

ANmaReplace_Occurrence

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

2024Jul13

SwitchTextinCells

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

2024Feb23

ReplaceStrings

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

2023Nov11

Column1Range

Return range of cells in column having data where, ignoring header cell and ...

2023Oct7

MultiTrim

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

2022Dec3

SwapNumbers

Swap two numbers variables without using third variable A trick worth saving ...

2022Oct17

CleanFilename

Cleans file name from invalid unexpected characters that Windows refuses.

2022Feb22

Old cell value

Nice solution to read value in cell AFTER changed. Needed to have that feature ...

2021Dec30

NMRRank_v2021

Ranks a number among set of numbers. This is part of huge tool, we needed to ...

2021Sep23

ANC Bootstrap controls (Testing < and & # 6 0 ;)

Testing step in site (or in each HTML output function to replace < with < ...

2021Jun9

ShapeRange_BG

Replaces the background fill of any shape in Excel with an image Not Ready yet, ...

2021Mar27

Regular expressions (Notepad++)

How to do regular expressions in Notepad ++ search and/or replace Helpful when ...

2021Mar10

InSheet_ChangeImage

Allows users to inserts image into sheet, replacing old one, with ability to ...

2021Feb20

1 2 3 4 5