Search results 669

Sorted from new to old.
Card image
SortArea5

Sort range or area by 5 columns, range can be any number of columns, but the ...

Card image
FileDateTime

Gets time and date for a file, Date created, accessed or modified. If the file ...

Card image
PI

Returns a double representing the mathematical constant Pi

Card image
SortArea3

Sort range or area by 3 columns, range can be any number of columns, but the ...

Card image
SortArea1

Sorts a range or area by 1 column given its cell address, with options to ...

Card image
Sort1Col

Sorts a column in Excel, easily, with options

Card image
strUnQuote

This will tests to see if strQuotedString is wrapped in quotation marks, and, ...

Card image
DegreeC2F + DegreeF2C

Convert Celsius to Fahrenheit and Fahrenheit to Celsius degrees

Card image
Capitalize

This function capitalizes first letter of each of the words in a sentence, ...

Card image
Page area and Page Setup functions (Unfinished)

Clear Excel print area, or set it, or read it, along with Page setup commands ...

Card image
SharePointURL2Path + Path2SharePointURL

Converts SharePoint URL to regular folder path and the other way, giving the ...

Card image
HTMLTag + HTMLPair

Generate HTML tags with thier parameters as name=value pairs ' Example of ...

Card image
FormulasFlatten

Fill in formulas from 1st row, then convert them to flat values to avoid Excel ...

Card image
WordsOf + Words_Len

WordsOf to create list of words from a block after converting every special ...

Card image
Distance_Calc_fromString

Calculate distance between two points (Latitude, Longitude) LatLon1 and ...

Card image
NMACode

Converts all Ƽ found in a string into their actual chars