Excel Forum
Similar Content
Simple Excel Function to Extract a Word or Text from a Cell
Tutorial: Excel function that makes it easy to extract a word or text from a cell in Excel. This is ...
Quickly See All Cells linked to a Formula or Function in Excel
Tutorial: Ill show you how to see the cells used in a formula/function in Excel and also how to tel...
Error Values in Excel - Full Explanation
Tutorial: Here, I'll teach you what the errors in Excel mean.  There are many errors that you can ...



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.





Got a Question? Ask it Here in the Forum.