Split messy data into neat columns with Text to Columns
If you’ve ever been given a spreadsheet where names, dates, or codes are all squashed into one...
If you’ve ever been given a spreadsheet where names, dates, or codes are all squashed into one...
If your imported text looks odd, Excel has clean-up formulas that fix it in seconds:
=TRIM(A1)...
Need a quick sum, average, or count from your data without any hassle?
Highlight your data and press Ctrl + T to turn it into a dynamic Excel Table. You’ll instantly get...
If you ever spend time retyping patterns of information like splitting full names into first and...
Ever been in a large Word document and needed to look at two parts of it at the same time? Or a...
Please see below two really quick ways to select text in a Word Document:
If you are researching and reading lots of complex websites, you can ask Copilot in the Edge...
If you need to highlight all the blank cells in an Excel list, you can use this simple shortcut:
If you have multiple Excel files you need to combine in to one list, Power Query may have the...
Never miss an update. If you want to stay tuned with our latest tips and hacks then subscribe to our emails. Get all our updates delivered straight into your inbox.