Split And Join Substitute And Perform Surgery On Text Strings
Convert text to lower case Example: =LOWER("hello") Result: hello
Recent posts
Special Characters And Symbols
You can always use the Insert –> Symbols method to enter characters onto your spreadsheet but you can also add them via a formula.
Percentage Variance With Positive And Negative Values
There are 2 formulas to calculate percentage variance (change).
Workbook And Sheet Name With Aormula
These formulas require that the workbook is saved
Multiple Criteria Lookup With Index And Match
We can expand on the Index and Match formula and use an array formula to look up a value based on multiple criteria. This is an array formula so need to pre...