Search results 87

Sorted from new to old.

Column2AnString_Unique

Creates list of unique items found in a column, returns string with items ...

2020May6

ANSQLWherein

Creates list of items to be used in ' Where item in (List)' list Mainly adds ...

2020Jan6

ImagesIn_User

Gets images in a folder where filenames start with "User" Similar to function ...

2019Dec31

Rows 2 Cell

Convert items found in a column matching certain material into list in 1 cell ...

2019Jul30

GetWordCount

Counts how many words found inside a string. Using space, tab or enter as ...

2019Mar31

Split string into table

Returns tag words (as table) in Microsoft SQL Separator set to comma, but you ...

2018Dec18

ImagesIn

Just like FilesIn function, but this one returns list of images only found in a ...

2018Nov24

Files_MostRecentN

Gets most recent N files from a given folder. Uses Arrays, and the function ...

2018Oct1

Arabic SQL+ASP

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

2018Sep24

Hand.cur

A cursor file type of Hand. used inside VBA to show hand when user hover over ...

2018Aug14

ApplyValidation_DropDown

Adds Validation drop-down to a cell (Data --> Validation --> List), or to a ...

2018Aug10

FixPath_Word

Fixes the path for a given folder, PC or Mac by adding separator only if ...

2018Aug9

FoldersIn5

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

2018Aug8

ExportSheets_to_1PDF

Export multiple sheets as pages in 1 pdf doc. Passing list of sheets as ...

2018Aug8

FoldersIn

Returns list of folders found in given folder in a string in ANStr format, ...

2018Aug3

RandomRecords

Returns random IDs (or any column) from SQL Database table, passing number of ...

2018Jul29

1 2 ...4 5 6