Excel Trim Formula
How many times have you tried to import a file into Excel, only to have extra blanks all over the place in the document? Well that’s where the Trim Formula can come into play. The Trim formula is used to clean up and remove all the leading and trailing blanks as well as all but one blank in-between [...]
Excel Length Formula
The Excel Length formula is a useful formula that can be used in many different circumstances. I’ll be showing a few of the useful examples of it below. But first let’s take a look at the formula itself: LEN(text) where text is any string you want to find the length of. This formula is really [...]
Match Formula in Excel
The Match Formula in Excel is an easy way to have excel look through an array of values and return the relative position if the match is found. The difference between this and the lookup functions (eg. Vlookup) is it return the position of the item and not the item itself. Let’s go ahead and [...]
Rank Formula in Excel
The Rank Formula that is built into Excel can be a very useful way of speeding up the ranking of several items. Let’s take a look at the formula and see how this can help us out: =rank(number, ref, order) where number is the number whose rank you want to find; ref is a reference [...]
Hyperlink Formula in Excel
I’m going to add this section to the Microsoft Excel Help section (menu on the left) of the website. An excel user contacted me and questioned how to create a hyperlink inside of excel using the value in another cell to as part of the link. The Formula looks like this: HYPERLINK(link_location,friendly_name) where link_location is [...]
