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

Got a Question? Ask it Here in the Forum.