Results for:
Data Cleansing_2F00_Manipulation

• Clean up imported or pasted data in Excel

  20 Sep 2011

  The data in your beautiful spreadsheet doesn't necessarily start out that way, especially if you've copied or imported it in from some other place. By using some Excel functions and formatting techniques, you can make your names, dates and numbers look just the way you want. Chad Rothschiller, an Excel...
• Get data into Excel by importing it

  13 Sep 2011

  If you've worked with Excel long enough, you've probably needed to get data into Excel so that you can analyze it, or maybe create a chart. Where does this data come from? It might come from a database or some other program, or even the web. And it can come in a variety of forms. Whatever the case, I...
• Formula to Access a List of Values Interspersed with Zeros or Blanks

  30 Jun 2009

  Today’s author is Bob Umlas, an Excel MVP since 1994, and author of This isn’t Excel, it’s Magic , a book that is filled with tips and tricks for getting the most out of Excel. This tip is a formula which enables you to access a list of values interspersed with zeros or blanks and pick up only the non...
• Hidden and Invisible Objects

  30 Jan 2009

  Today’s author, Ben Rampson, a Program Manager on the Excel team, talks about cleaning up spreadsheets. I often receive files demonstrating issues customers are experiencing with Excel. Recently I have noticed a common problem in some of these files that impacts the file’s performance and size: hidden...
• Repeating a Set of Data

  20 Jan 2009

  I thought this would be interesting to share to see how other Excel folks might have solved this problem. I got a question recently from a customer asking how to automatically take a set of values in one column, say: 1000 5000 600 and repeat each value, say, 4 times in the next column, so that it looks...