Learn how to remove unwanted space characters from text data in Excel using various methods.
4 Ways to Remove Unwanted Space Characters
read more
Functions | Power Query | Tutorials | VBA
How To Automate Sorting, Hiding, Unhiding and Listing Your Sheets
It's often the case that workbooks get very large and end up with a lot of...
How to Create Delete and Rename Folders from a List
I started making videos to go along with my post on pivot tables called 101...
How To Export Your Data Into Separate Workbooks Based On The Values In A Column
Something that comes up time and time again in any kind of work is separating...
How To Check If A Worksheet Exists Using VBA
There may come a time when you need to know if a sheet in a workbook exists...
How To Find The Nth Item In A Comma Separated List
Let's say you have a column of data and in each cell you have a text string...
Get The Latest News
Follow Us
Follow us on social media to stay up to date with the latest tips in Excel!