Worksheet name, dynamically using formula
Get the name of the active worksheet in active workbook, using formulas only This function needs to have workbook saved Then, you just paste below formula into any cell …
Month: April 2018
Text-to-Columns, dynamically using formulas
I often use the technique of concatenating columns into 1 cell with separators. Something like the CSV, 1 line that has all values for a single row (all columns for that row) into 1 text block. And then, because of that, I need to extract that back, into table