MS Excel Tips - Five Simple Ways to Cleanse Your Excel Data

generally have little control over the data is imported in any format or type. It could be separated by commas value (CSV​​) from the database, or even the web-site, but more than likely to be disorganized and dirty.

We start with the most simple way to tidy up and clean up your data. These are my top five simple ways to begin the process of data cleansing.

1. Delete unnecessary rows and columns, and could be empty columns and rows, or the extra columns and rows of data that you just do not need. It is easy to only select the columns / rows and hit Edit-Delete. Excel version 2007 onwards use the Home tab, Cells group-Delete.
   
2. the size of your rows and columns. Sometimes all you can see the station is full of ##### characters. Just double-click the box to the right column letter or row number below to view the whole cell. So you can see the design and content of the cells involved.
   
3. Deleting unneeded cells content. They just clutter the worksheet. For Excel 2007 onwards tab - Edit Group - Clear - Clear All. For older versions Edit - Clear - All command.
   
4. Use of Clean. This is a command and use the most when they begin to clean the data. This will remove the printing of text characters that sometimes end up being the odd shape of the sheets. This cleans up the text can be stored in the second column, usually with the original data which you can then use the following syntax raditi.Clean CLEAN (text). Text argument to this function is a text string or a reference to a cell that contains the text string you want to clean. For example, for cleaning the data stored in cell D1 you would use syntax cyst (D1).
   
5. Use the Find and Replace. This is one of the most important commands Commons simply clean and tidy your information. If you use Excel 2007 onwards, then highlight the column or columns that contain data you want to clean, use the tab - Edit Group - Find and select. Use dialog boxes to enter what you want to find and then I want to replace it with. If you use a pre-Excel 2007 and use the Edit - Replace and enter it in the dialog box in Excel 2007

These five basic functions should begin to get disorganized and dirty any data you may have imported or inherited in a more user friendly and cleaner form of work.