Excel At Work

Excel sheets can drive you crazyDo you share this pet peeve?

I go a little nuts when I have to prepare a large mailing list and a bunch of the names all start in lower case.

With the increase in online petitions and surveys the problem is only getting worse.

Nothing says form letter like “Dear brendan”, but can you think of anything more tedious than scrolling down an excel sheet fixing names?

So here is a short cut.

You can use the text formulas in Excel to find and replace the first letters of a name field with a capital letter, then recombine them into the proper names.

(Hit the picture to enlarge)

Save Those Names

You can grab a copy of the excel sheet I made here and use the formulas to clean your next mailing list.