Excel Forum

Excel Magic Trick 619: Space in Cell Causes Trouble in Formulas. Replace, COUNTA, CLEAN, TRIM

See how spaces in cells cause trouble in formulas. Learn about these topics:
1. Replaces feature to remove spaces
2. COUNTIF function to count cells without spaces
3. CLEAN function
4. TRIM function

Got a Question? Ask it Here in the Forum.