Dueling Excel 031

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
and more
Mr Excel does an elegant solution with VBA


Be the first to comment

Leave a Reply