January 6, 2014
Excel TEXT Function – handy but limited…or is it?
At first glance the Excel TEXT function appears quite limited. Its purpose is to convert numbers to text in a
Read More
September 4, 2013
Extract Text from a Cell using MID Formulas
Last week we looked at how to use Excel’s Text to Columns tool to extract the domain name from a
Read More
August 14, 2013
Excel Test if a Range Contains Text, Numbers or is Empty
I received an email from Bill this week asking how he can check if a range of cells contains text
Read More
July 17, 2013
Excel CLEAN Formula
Ever copy and paste some data from a web page, or import it from another program, and end up with
Read More
July 17, 2013
Excel SUBSTITUTE Formula
The Excel SUBSTITUTE function replaces new_text for old_text in a text string. The Excel SUBSTITUTE Function Syntax is: SUBSTITUTE(text,old_text,new_text,[instance_num]) The
Read More
July 4, 2012
Excel Factor Entry 3 Re-format Data Using Formulas
Importing data into Excel from other systems rarely goes without the need to fix formatting before you can even use
Read More
August 24, 2011
Excel SEARCH and You Will FIND
In Excel there are two almost identical functions; SEARCH and FIND. The SEARCH and FIND functions allow you to find
Read More
July 13, 2011
Excel SUBSTITUTE Function Trick
Each time I write a tutorial I use the Google Keyword tool to find search phrases that are relevant. I
Read More
June 1, 2011
Excel TRIM Function Removes Spaces From Text
If you import data from another program it often comes in with additional spaces either at the beginning, end or
Read More
May 25, 2011
Excel UPPER LOWER and PROPER Functions
Sometimes when you import text from another source it may not be formatted in the case you want. For example
Read More
March 11, 2011
Microsoft Excel’s T Function
Did you know there are only two functions in Excel that consist of one character? They are T and N.
Read More
March 7, 2011
How to Join Text Together in Excel Using CONCATENATE and &
Often data imported into Excel from another system isn’t quite in the format we want. Text can be split across
Read More