Solution Category: Data Editing
data-editing
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 – 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)
Changes first character in strings within selected range to lower case.