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 …
Category: Texts and Strings
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 …
Count how many times letter found
Found this in an old file while doing some digital cleaning This will show you how you can easily count how many times a letter (or any string) into a …
Multiple lines in cell using functions
You must already know that when you press Enter after you modify a cell, the cell content will be saved and you jump down to cell below (we can change …
Extract current (Active) workbook name
I need that more often than I thought It is basically extract the full workbook name that we are in, with no folders, and with no extension =MID(CELL(“filename”,A1),SEARCH(“[“,CELL(“filename”,A1))+1,SEARCH(“]”,CELL(“filename”,A1))-SEARCH(“[“,CELL(“filename”,A1))-6) So, here …
Get column name (or headers or address as A,B,C, etc) as input inside cell
Excel already has the formula ROW() =Row() Which as we may already know will give us the number of the row we are in, if you add no parameters However, …
iframe in Excel (XLiFrame)
This is the iframe in Excel, if you are familiar with the HTML concept of iframe, you will understand this one right away, it is basically the same project as …
Zipcode-State search
Enter a zip code, and Excel will tell you in which state it is It also has a list of all zip codes for all states and a technique (INDEX …