|
Featured Tutorial
Featured Macro
Mr Excel & excelisfun Trick 31: Word Wrap Problem: Formula or VBA solution?
excelisfun does 15 tricks in one to go from a bad data set to a good data set:
1)GoTo Special Blanks
2)Ctrl + Enter to populate cells with formulas
3)IF function
4)Logical Formulas
5)Ampersand Join Symbol
6)Double Quotes for blank
7)Sort
8)Filter
9)Delete Columns
10)and more
Mr Excel does an elegant solution with VBA.
1)GoTo Special Blanks
2)Ctrl + Enter to populate cells with formulas
3)IF function
4)Logical Formulas
5)Ampersand Join Symbol
6)Double Quotes for blank
7)Sort
8)Filter
9)Delete Columns
10)and more
Mr Excel does an elegant solution with VBA.