Tag: filter

IT Word Cloud

Separate All Text to the Right of a Word in Excel

I was recently using an application which exported a report into Microsoft Excel format. The report separated most fields into separate cells, but for some reason, it combined certain fields together into once cell. Unfortunately, I needed a way to separate the combined data into two cells so I could use a filter.┬áThe combined data […]

February 6, 2011 | 0 Comments More
Letter D

Remove Middle Initials in Excel

Occasionally, I need to compare two or more lists of names to determine any matches across the lists. Depending on the sources, the formatting of the lists may be completely different. Even minor differences in formatting can result in a challenging comparison in Microsoft Excel. If you run a quick Google search online regarding the […]

December 4, 2010 | 0 Comments More
GMail - Filter Unread Emails

Show Only Unread Email in GMail

So you just setup a ton of filters in GMail to separate the clutter from your precious inbox. The next step is to read and/or delete all of the emails in your inbox which have managed to “slip through the cracks” over the years. The inbox can be filtered to show only unread email by […]

September 7, 2010 | 0 Comments More