Left, Right and Mid Formulas in Excel
One of the easiest ways to manipulate a string is by using the left, right and mid formulas. There are many times when users of excel are given a long string and only need a certain section of that string to get the results they desire. Using these formulas will greatly reduce the number of [...]
Concatenate Formula in Excel
The Concatenate function is a function that I use almost every day. There are numerous times where you will have data split into many columns but need to look up a value that is unique to the combination of two (or more) of those columns. That is where the concatenate formula comes in handy. Let’s [...]
Date Formulas in Excel
Some of the more common formulas I use on a regular basis are date manuputation formulas. Whether it using the Date() formula or the Month() formula or many others, there are several ways to show data that have dates involved. Let’s start by taking a look at the Date Formula itself: Date(Year, Month, Day) where [...]
HLookup in Excel
I thought a good next post would to add how to use HLookup after posting the VLookup information last time. The two functions are very similar only they do the opposite things with it comes to looking a against a table. Let’s start by taking a look at the formula for HLookup: HLookup(lookup_value, table_array, row_index_num, [...]
VLookup in Excel
The Vlookup Function is a part of Excel that I personally use everyday. So many Excel users have no idea it even exists, so I thought this would be a great place to start for ExcelHints.com. Once you learn how to use vlookup, it will greatly ease many of the pains you have had in [...]
