Adds spacing characters in front of numeric ids so that their length is the same. ie 10 & 200 could be converted to 00010 & 00200. This allows for correct alpha-numeric sorting. Instead of data being sorted as [Team 1, Team 11, Team 2, Team 3], it will be sorted as [Team 001, Team 002, Team 003, Team 011]
Returns the day number (ie how many days have passed in the year)
Open dialog box to select desired folder
Returns the text before the specified character or the nth instance of the specified character
Returns the text after the specified character or the nth specified character
Returns the text between specified characters – eg. specifying “fox” and “here” for “the fox jumped there” returns ” jumped t”
Combine online survey data, column wise, from different worksheets containing aligned data – Note: The 256 column limit that created the need for this routine is a thing of the past. There could be circumstances where it is useful but in general, it is considered obsolete.
Concatenate all cells in range with an optional separator
List all worksheets as a named range using cell ‘A1’.
Adds comments to cell(s) using text from the cell directly underneath the selected cell(s)