Search results 680

Sorted from new to old.
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

Card image
UTF8R_toChar

Converts characters created by program R into actual chars as in < U+641 > to ...

Card image
TextPercentageMatch

Matching any part of a string in another , then returns 0 if not match, Or ...

Card image
WeekNum

Generates the calendar week number for a certain date, counting the first week ...

Card image
SettingRead_JR

Reads setting saved in columns J:R Just like SettingRead, but when we have ...

Card image
CreateGUID

Generate random GUID of 36 chars (with or without brackets) using TypeLib ...