OFFSET Function. Get a cell by specifying the distance from the reference cell, height and width.(Microsoft Excel)
Includes usage of the OFFSET function and examples of its use.
CONCAT Function. Concatenate strings.(Microsoft Excel)
Includes usage of the CONCAT function and examples of its use.
Read text and table data from images.(Microsoft Excel)
Introduction to the use of OCR added in October 2022.
Formula to randomly extract a specified number of cells from a range of cells.(Microsoft Excel)
Introduces formulas with examples of creating passwords.
Formulas to randomly reorder a range of cells.(Microsoft Excel)
Includes formulas and examples of use for random sorting.
Formulas to extract text from a cell every specified number of letters.(Microsoft Excel)
Includes formulas for extracting a few characters at a time and examples of their use.
Formulas to sort text in cells.(Microsoft Excel)
Includes formulas for reordering cell values and examples of their use.
Formulas to remove multiple types of characters from cell text.(Microsoft Excel)
Includes formulas and examples of using the SUBSTITUTE and REDUCE functions in combination.
Formula to split text into cells one character at a time.(Microsoft Excel)
Includes formulas for splitting horizontally and vertically.
WRAPROWS and WRAPCOLS functions. Sort specified range of cells in a single column or row by a specified number of rows or columns.
Includes usage of the WRAPROWS and WRAPCOLS functions and examples of its use.