Jan 29 2010

Using Text to Columns to Separate Data

This post can be seen as a follow up to an earlier post, Separate Full Name into First & Last Name.  Excel provides a very easy to use tool to separate delimited data into multiple columns.  All that delimited data means is that your data is separated into different sections by a character(s), usually a tab, comma, percentage sign, etc.  The same can be done with a macro or group of formulas, but it really is easy and convenient to use this built-in feature.
Read More

Nov 29 2009

Macro to Disable Cell Calculations on a Sheet

If you’ve ever had a sheet in your project that has a number of formulas with calculations, you’ve no doubt noticed the slowdown that occurs when saving your spreadsheet or editing a formula.  Excel has a property that can be adjusted within a macro that allows you to turn on and off the calculations on a spreadsheet.
Read More

Oct 25 2009

List Unique Values from a Range

Excel has an easy built-in way to show the unique values from a list of numbers you provide. You can use it to filter a unique list of numbers, dates, strings or whatever you need to have listed.
Read More

Oct 9 2009

How Do I Get Just the Last Word from a Cell?

This is an example of a question I recently received in the comment section of a post that I think others will find useful.
Read More

TAGS:
Oct 9 2009

Ask Your Questions to Excel Hints

I receive questions all the time from readers of excel hints, both through the contact form as well as questions posted in the comment sections of posts.  So let’s start sharing some of these with everyone.
Read More

TAGS:
Page 1 of 1512345»...Last »
  • Get Expert Excel Help Today! 714.262.6893

Categories

Excel Poll of the Week

How often do you use Excel at work?

View Results

Loading ... Loading ...