by Nate Moore | Jun 8, 2011 | Functions
DATEVALUE doesn’t get the tax returns of the date your daughter just introduced, but Excel Video 164 does show you how to use DATEVALUE to change text to a date. Just like Excel Video 162 changed text to values with the VALUE function, DATEVALUE changes text to a...
by Nate Moore | Jun 6, 2011 | Functions
NOW and TODAY sounds like the name of a bad soap opera, but they’re two functions to get the current date and time that we’ll discuss in Excel Video 163. The NOW function retrieves the computer’s date and time, while TODAY retrieves the computer’s date. Note that you...
by Nate Moore | Jun 1, 2011 | Functions
Excel Video 162 helps you convert text to values and values to text. Before Excel 2007, I used the VALUE and TEXT functions a lot more than I do now. I’ll show you what I do now to convert values to text and text to values, and then I’ll show you how to use VALUE and...
by Nate Moore | May 30, 2011 | Functions
Excel Video 161 helps you repeat helps you repeat text as many times as you want you want. I don’t use the REPT function as much as I used to, but there are a few instances when you may find it helpful. Essentially REPT repeats whatever text you enter (remember to put...
by Nate Moore | May 25, 2011 | Functions
Excel Video 160 covers another easy Excel function. This time we’ll use TRIM. TRIM simply removes extra spaces from text. Older data systems occasionally filled any extra space at the end of the data with actual spaces. TRIM is an easy way to get rid of those spaces....