Posts Tagged ‘enter’

Clean Up Copied Data in MS Excel Easily

Monday, February 16th, 2009

Sometimes when you copy and paste data in MS Excel you copy over non-printing character and other strange looking things that you did not intend to copy.

Well the good news is that there is an easy way to clean up that data with a very easy to use MS Excel function called the Clean Function.

Follow the steps below to learn how:

  1. Select the cells with the data that needs to be cleaned.
  2. Enter the following formula: =CLEAN(A2) or whatever cell you are referencing.
  3. Click CTRL + Enter.
  4. MS Excel will now display the contents of the cells without the non-printable characters.

You can now copy the results to another part of your workbook using the Paste Special option to copy the values without the formulas.

Tags: , , , , , , , ,
Posted in Excel 2003, Microsoft Office, Microsoft Office Excel, Office Productivity | No Comments »

Working with Database Files in MS Access

Thursday, February 5th, 2009

When I first started using MS Access and downloading databases I was really confounded when it came to renaming the database.  When I tried to use File | Save As, it came up with something other than what I expected or wanted!

Well now I have learned how to accomplish this simple task (it’s always simple once you figure it out, isn’t it?) and I will share my knowledge with you.

All you really need to do is change the name of the .mdb file. You can do this from My Computer or Windows Explorer. You can even do it from Access itself!

Follow the steps below to learn how:

  1. Close your database file if it is open.
  2. Click on File | Open.
  3. Navigate to the File in the open dialog box.
  4. Right-click the file and select Rename.
  5. Type a new name for your database.
  6. Click Enter.

Before you set out to rename your database, remember that MS Access does not automatically update links, so if any other database links to a table in the database whose name you would like to change, you will have to open that other database and redo the links. You would, of course, use the Linked Table Manager to accomplish this.

Tags: , , , , , , , , , ,
Posted in Access 2003, Microsoft Office, MS Access | No Comments »