Search results 43

Sorted from new to old.

Subtotal_Indirects

Finds the SUM, COUNT, COUNTA, etc for a range of cells referencing using ...

2021Nov26

Special chars

How to type special characters in keyboard using ALT + keypad numbers I also ...

2021Oct13

Long filename

How to delete or rename file with long filename, say more than 200 chars. ...

2020Oct11

IntlIsAlphaCharacter

Test if a character is alphanumeric, regardless of the code page or language ...

2020Mar21

Remove_Between2Quotes

Remove any char (or string) found between two quotes in a string This is an ...

2020Mar9

AN_SafeFileName

Clean filename from special characters to make it safe for server upload Then ...

2019Dec10

ShrinkText

Shrinks a text into smaller text controlling where is the majority will be ...

2019Oct20

Char(39) in SQL table

One of many ways to go around the issue of char 39 in SQL database

2019Aug31

HTMLDecode + HTMLEncode

Decode and encode back a string using HTML Technically found online, but ...

2019Aug9

Arabic SQL+ASP

Enable Arabic in MSSQL DB, the correct way, as of Sep 2018 Tested in Alwah and ...

2018Sep24

GenerateRandom

Generates a random string, returns string passed, then full date, then 8-chars ...

2018Sep12

DigitsORLettersOnly

Check if the string has special characters or not, only Letters or digits ...

2018Aug8

FoldersIn5

Creates list of subfolders and subfolders of each down to 5 levels Folder ...

2018Aug8

CutString_Words_Left + CutString_Words_Mid

Cuts the left or Middle part of string without breaking words Can specify ...

2018Aug8

UnBreakAr + BreakAr

Fix broken Arabic char, by using AscW and ChrW This is Excel User-defined ...

2018Jul25

ProtectText + UnProtectText

Encrypt or decrypt text, simple encryption with a numeric password Decrypt a ...

2018Jul19

1 2 3