Excel Forum

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
9)Delete Columns
10)and more
Mr Excel does an elegant solution with VBA.

Got a Question? Ask it Here in the Forum.