How to remove unwanted characters in Excel spreadsheets through the Left, Right and Mid functions Jun 20, 2012
How to extract characters from the left, right or middle of a excel cell
Home // Blog & Excel Tips // 79
Blog & Excel Tips
Free Tips & Tricks Newsletter Please fill in your details below to get regular Excel tips and tricks and a free Quick Reference Download!
Blog entries covering the latest Excel tricks and tips based on queries from clients and practical knowledge from our consultants.
Request info on training dates, prices and venue
Using the AVERAGE function to calculate averages in Excel models Jun 20, 2012
How to use the AVERAGE formula in Excel to calculate the average of a set of numbers
Working with Trace Precedents from the Excel spreadsheet auditing toolbar Jun 20, 2012
How to use the trace precedents button in the Formula Auditing toolbar
How to avoid the RANK function finding equal results Jun 20, 2012
How to solve the problem of the rank function returning the same value.
Drop down cells and looking up related information Jun 20, 2012
How to base a drop down list on the outcome of another dropdown list
How to rank items that have the same rank?? Jun 20, 2012
How to address the issue where the rank of items needs to be the same but the Excel RANK function ignores all but one of the ranks
Green Marks inside Excel cells Jun 20, 2012
Explanation of what the little green notes inside Excel cells are and how to use them
Consulting
We aim to provide the ultimate, one stop shop for all Excel users requirements, within South Africa and worldwide.
Live Training
"Recently we had a most successful in-house training session at our company. I would like to extend my thanks and gratitude."
Free Excel Tips & Tricks delivered straight to your mailbox. Sign up today.