Returns the day number (ie how many days have passed in the year)

Dale Anderson

Open dialog box to select desired folder

Dale Anderson

Returns the text before the specified character or the nth instance of the specified character

Dale Anderson

Returns the text after the specified character or the nth specified character

Dale Anderson

Returns the text between specified characters – eg. specifying “fox” and “here” for “the fox jumped there” returns ” jumped t”

Dale Anderson

Combine online survey data, column wise, from different worksheets containing aligned data – Obsolete

Dale Anderson

Concatenate all cells in range with an optional separator

Dale Anderson

List all worksheets as a named range using cell ‘A1’.

Dale Anderson

Adds comments to cell(s) using text from the cell directly underneath the selected cell(s)

Dale Anderson

Changes first character in strings within selected range to lower case.

Dale Anderson