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
Just purchased and downloaded. File is unreadable by Adobe Reader. Reader says it's either not supported or damaged