Search results 117

Sorted from new to old.

ANmaReplace_Occurrence

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

Jul13

ANmaCellFormat

Reads or set Numberformatting for a cell or range. Can pass sheet and workbook ...

Apr18

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

Converts two bytes to long

Functions to convert two bytes to a numeric value (long), (both little-endian ...

Jan14

UnUnixDateTime

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

Jan6

Protect txt file into word doc with password

Saves txt file as word doc with password. Passing txtfile having full path and ...

Jan4

ChartLegendCenter

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

2023Dec21

SQL Date from DateTime

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

2023Nov29

UserChanged_Log4

Adds date to column1 when user enters text in column2. Also, if user remove ...

2023Nov28

ReplaceStrings

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

2023Nov11

AddressReferenceStyle

Change Address style from R1C1 to A1 or from A1 to R1C1. Something I needed ...

2023Nov1

Any2Dec

Converts a number of any base to decimal. Hexa to decimal, octa to decimal, ...

2023Sep20

SheetTabColor

Applies certain color to sheet tab in Excel. ColorNumber is Excel ColorIndex. ...

2023Aug17

Arr_1Dim_2Str

Converts 1-dimension array into text. Meet Join. A way to convert array into ...

2023Aug14

1 2 ...7 8