Ever needed to convert the text Sep or September into a 9? Well Excel can convert text months into their respective numbers.
Being able to extract the current sheet name is often handy. Sheet names have to be unique, so you can name your sheets after departments or divisions. Excel will stop you duplicating a sheet name.
Pivot Tables are incredibly powerful and easy to use. Unfortunately their headings can include the terms “Sum of” or “Count of”. This is not always what you’d like to present to users. A macro to the rescue.
Sometimes when you import data via a CSV (Comma Separated Values) file or a TXT file, the dates don’t always import very well.