Archive for the ‘Excel’ Category

Clean Up a Column of Mixed Date Formats Tool

Sunday, December 12th, 2010

A few times a year, a client of our will need our help in cleaning up a manually populated Excel file that has a couple of date columns. Invariably, there is a hodge-podge of date entries, such as 2010-10-05;  june 10, 2010; or 8/4/2008.  We’ve finally made a tool to fix up the bulk of this so that Excel will detect it properly as a date value.

Perceptus introduces the  Clean and convert a column of dates in Excel Numbers Wizard, on the Perceptus Web Tools mini-site.

We hope this tool saves some people besides ourselves some time.

 

Create a single line of text from a table for logging

Monday, June 15th, 2009

Have you ever wanted to copy a chunk of text from a web page for logging in an Excel spreadsheet and have been supremely annoyed by the formatting and spacing and all manner of other things that make it untidy and tedious?

Well, we did.  So, a couple months ago, we added a new text mangling tool to our simple web tools page, we introduce, The Simplify to a single string – granted, we don’t have the prettiest names for our web tools.

It was originally designed to online transaction details from a bank web page that includes a small table, and turn it into a single string that we save in Excel for logging purposes.  It’s turned out to be useful for mangling all sorts of web snippets to make them Excel, Word, and even email friendly.

We strip all formatting, remove extra spaces, and modify table cells and line breaks by replacing the breaks with dashes (“-“).

It’s useful to us, and hopefully to you!  Enjoy.