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.

Category:

Science & Technology

Tags:

• Excel
• Word
• Wrap
• Data
• Import
• Problem
• Formula
• VBA
• excelisfun
• Bill
• Mr
• Jelen
• Mike
• Gel
• Girvin
• Highline
• Community
• College

[himalarohee]

That is a great video, Mike. Thank you for showing two approach and it seems like your formula works for any number of words separated. Really liked your video

[ExcelIsFun]

@himalarohee , glad that you liked it!!

[Laydjo1]

Seeing two different approaches to an excel problem is (formula and VBA) is just great. Mike, although a lot of us think that you should include VBA in your solutions, I think you deciding on leaving the VBA part to Mr Excel is a good idea. It helps beginners like me understand formulas better before we jump over to VBA.

[ExcelIsFun]

Yes! I am just like you you - I am not a code writer, but I can at least use Excel!!

I am glad that the videos helps!

[kayno9]

Mr ExcelIsFun (Master of Formulas),

I think you and Mr Excel should author a book from all these dueling videos as these are real life problems and therefore may relate to the masses. Just a friendly suggestion :)

By the way i love your videos and both of you are unique in your own styles. Keep up the good work.

[ExcelIsFun]

Thanks!

That is a great idea. You should send a note to Bill Mr Excel Jelen.

He is bjele123 at YouTube!

[ExcelIsFun]

Wow! So you are now a VBA Excel master, or at leat you can use it, right?

I have read his books on VBA and have the video, but have only watched the first 10 or so...

[hamy72]

I got that way back in April when it was released on Amazon. LIke most of his products, its fantastic and must for those serious users!

[ExcelIsFun]

Mr Excel has an amazing series of videos about VBA. You can get it at his web site for about $49.

But, yes, I don't do VBA too well...

[hamy72]

Hey Mike with your excel skill and aptitude I don't think mastering Excel VBA should be all too difficult.

(Then may be we could have another set of Video Tutorials on VBA....... lol!)