July 2010

The RIGHT Function in Excel

July 31, 2010 Formulas
Thumbnail image for The RIGHT Function in Excel

The data you see in column A is a text string output from a database. I need to extract the Date, and have used the MID Function to get the Month and Day, yet need to include the Year value as well. For this data the RIGHT Function is appropriate because the Year value is [...]

Get the full story …

The MID Function in Excel

July 29, 2010 Formulas
Thumbnail image for The MID Function in Excel

By looking at my exported data you can see the Dates in column A are really just a bunch of Text. The database export format spacing is standard: Day of the Week, space, Month, space, Day, space, Time, space, Year. I want to extract the Month and Day by using the MID Function. In cell [...]

Get the full story …

Extract a Date from Text in Excel

July 27, 2010 Formulas
Thumbnail image for Extract a Date from Text in Excel

It’s not uncommon for database programs to export data in a text format. I downloaded some data from a web browser, and ended up with Dates that Excel didn’t recognize as Dates, but rather a Text string. In a previous post I used the Text to Columns feature to extract and convert the Month and [...]

Get the full story …

Excel Files on the iPad or iPhone

July 25, 2010 General Update
Thumbnail image for Excel Files on the iPad or iPhone

Documents To Go® Premium lets me open and modify Excel files from my Dropbox folder right on my iPad or iPhone. I can also access and modify spreadsheets from my Google Docs account. Excel email attachments can be downloaded, viewed and edited. This is a big plus when traveling with the iPad, or iPhone for [...]

Get the full story …

Different Versions, Different Methods in Excel

July 23, 2010 Intermediate

For the past week I’ve been showing how to remove duplicate values from a data range in Excel. How you go about that task varies, depending on the version of Excel you use. My simple worksheet example used only two columns, and only one had duplicate values. Excel 2010 and 2007 The Remove Duplicates feature [...]

Get the full story …

Removing Duplicates in Excel 2008

July 22, 2010 Intermediate

Excel 2008 for Mac requires more work to remove duplicate values in a data set because of it’s lack of features. Excel 2007 and 2010 have the Remove Duplicates feature. Excel 2003 and Excel 2008 for Mac don’t. In my last post I used a formula and the Find box to remove duplicate values in [...]

Get the full story …

Removing Duplicate Values in Excel 2003

July 17, 2010 Intermediate
Thumbnail image for Removing Duplicate Values in Excel 2003

I have a worksheet with duplicate values that need to be removed. There are two columns of data, with Date in column A and Weight in column B. The Date values are for each day and extend to the end of June. Some of the Weight values repeat as you can see in the picture. [...]

Get the full story …

Remove Duplicates in Excel

July 15, 2010 Features
Thumbnail image for Remove Duplicates in Excel

I use an iPhone app to record my food intake and exercise output everyday, and also record my weight, albeit infrequently. All of this data is synced to a database in the cloud. The database automatically enters my weight each day, even though I don’t, by using the last known data point. All of this [...]

Get the full story …

Text To Columns in Excel

July 13, 2010 Intermediate
Thumbnail image for Text To Columns in Excel

I recently downloaded and opened a CSV file from a web browser and one of the data columns was supposed to have date information. There was date-type information, but Excel recognized it as being a text field. I really needed a valid date range for graphing purposes, so I used the Text to Columns feature [...]

Get the full story …

Change Excel 2008 to Look Normal

July 10, 2010 Beginner
Thumbnail image for Change Excel 2008 to Look Normal

I’m new to the Excel 2008, the Mac version. Every time I open the program it just looks weird. What bothers me is that the default view is Page Layout. I guess it comes like that out of the box. The regular Excel programs (Windows) are all setup with a Normal page layout as the [...]

Related Posts Plugin for WordPress, Blogger...
Get the full story …

← Previous Entries