I thought I would resurrect these as they are so helpful on a daily basis.
This weeks was inspired by some work I did for a great organisation recently.
How do I format names or addresses that are a mixture of uppercase and lowercase characters?
Column A has randomly formatted text. Just type =proper(Cell Ref) in column B as per the picture below. If you want to keep these as your new column just copy and paste special values 🙂
Any questions just ask!