• Designs that distinguish
  
• Designs that get their attention
  
• Designs that spur them to action!
  
• Designs that keep them coming back
  
• WebPage Promotion for optimum visibility
  
• Content Management Systems
  
• Security - User Levels - Captcha
  
• Website Re-Design
  
• Online Catalogs
  
• Online Shopping Carts
  
• Intranets

• Why settle for less
  when you can have it all!
  
• Free Setup
  
• Up To 10 Gigs of Storage!
  
• Up To 2,500 Email Accounts
  
• SSL, CGI-BIN PHP MySQL
  
• Unlimited Email AutoSponders/Forwards
  
• Site-Builder
  
• Marketing Package
  
• Daily Tape Back-ups
  
• UPS AND Diesel Back-up Generator
  
• 24/7 Network Monitoring
  
• 99.98% Up-Time and Availability

1. WebSites are about making money! They are not beauty contests and they're not about flaunting technology
   
2. 80% of web pages are only seen by friends and family and never shows up on a search engine
   
3. In order to be effective your WebSite must be Found, Read, and it must Motivate your viewer to Take Action
   
4. This requires a good Plan, Design, Implementation, Promotion, and Maintenance
   
5. Organic Search Engine Optimization
   
6. Local Search Engine Optimization

Excel: Clean Up Data With Functions'

Submitted by gma on Sat, 09/10/2011 - 17:06

Excel includes a number of functions that allow you to remove printable characters, like spaces, from imported data. But what if your data contains nonprintable characters, like the ones shown in Figure A?

Figure A

To clean up this data, Excel provides the CLEAN function. Follow these steps:

1. Select C2:C10.
2. Enter the following formula:
   =CLEAN(A2)
3. Press Ctrl + Enter (Figure B).

Figure B

Excel displays the contents of the cells without the nonprintable characters. You can now copy the results to another part of the workbook using the Paste Special option to copy the values without the formulas (Figure C).

Figure C

---

‹ Excel: Chart Mystery Revealed up Excel: Convert A Calculated Result To A Value ›

• Printer-friendly version
• Log in to post comments