Search results 109

Card image cap
Refresh Table from View

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

Card image cap
SubZero

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

Card image cap
ANmaInt

Cuts the integer part of a number. Like INT, FIX, or CINT I know we already ...

Card image cap
DB Functions (By AI)

3 functions to add or update data to DB and Read from DB. These were also ...

Card image cap
Convert_Dash_to_Zero

Convert cells with dashes to zeros. Quick code needed to reset sheet copied ...

Card image cap
Range2Block

Concatenate all rows found in a range starting A1Cell for Columns_To columns ...

Card image cap
UnixDateTimeNumber

Calculates Unix date/time number of a given date/time. Needed it to pass ...

Card image cap
ANStr2Range

Converts a string of items into range, with custom separator. Opposite of

Card image cap
Range2ANStr

Converts sheet range to ANString, can work on any continued range, 1 or 2 ...

Card image cap
DBTable2CSV

Exports table into CSV from ASP Classic function.

Card image cap
DegreesToXY

Calculates X, Y of position on a Circle or ellipse. Pass the center X, Y of ...

Card image cap
Morse code functions

Convert text or single character to and from Morse code. TexttoMorse, ...