Excel Data Cleansing Tips (Electronic Download)

SKU: 310
Qty: - +
   - OR -   

This tip card is used by MCT Anne Walsh in her data cleansing seminar. Topics include:

  • How to remove extra spaces
  • Replace dirty data
  • Get only first N characters from a cell
  • Get just some bits from the middle of a cell
  • Get only the last 4 characters from a cell
  • Convert UPPER or lower case to Proper case
  • These look like dates, but Excel is not seeing them as dates
  • Show which quarter each date is in
  • Someone put all the data together in a cell. How can I break it out?
  • I see numbers. Excel only sees text. How do I make these real numbers?
  • I don't want to see the ugly DIV/0 or #N/A in my formula results
  • My data is in PDF. How do I get it into Excel?
  • Pivoting when months go across
Michael Collins on 05/21/2015 07:46pm
Just purchased and downloaded. File is unreadable by Adobe Reader. Reader says it's either not supported or damaged

Add Your Review

Your Name:
Email Address:
Note: HTML is not translated! Your email address will not be shared with anyone.
Your Rating: 5
Your Name:
Your Email:
Friends Name:
Friends Email: