Blank cells acting weird? Here's how to fix it!

[@caissa6187]

This is probably the MOST IMPORTANT lesson I've learned in Excel. I was struggling to the point of getting really upset. Your video has brought me back down to calm mode and am very happy. Thank you soooooo much!!!!!

[@pauljung-cp4yk]

This was the triumphant finish to understanding why I my ISBLANK formulas weren't working on data exported from Salesforce. And yes, the 'text to columns' hack is a great time saver. Very well presented - like a rockstar!

[@ruthbihonegn4968]

I had been grappling with a data issue for a whole week, struggling to understand the concept of empty text strings and their technical distinction from blank values. Your assistance not only solved the problem for me but also provided a clear and insightful explanation. Thank you so much !!!!

[@dycoconut]

Text to column solution was GENIUS!

[@DutchLufkin]

Thank you so, so, so much for this beautiful explanation. Your presentation is clear, well-exampled, and concise.

[@RockstarExcel]

Glad you found it helpful!

[@matthewsommerville88]

I had the same issue. After text-to-column procesedure with some data i copied. What worked for me was CTRL F, replace, then i entered one blank space with my space bar, and replaced that with nothing. It removed all those leading blanks that were being counted. So annoying, thanks for the video because it got my head in the right place

[@lizongzhang]

Thank you! Very clear! Easy solutions to the messed up blank cell!

[@jopsethguevara13]

Some cells came with a space and are easy to replace but the false blanks are really a pain...
Thanks for your help.

[@katarinasladoljev7855]

Thank you for your concise instructions. Unfortunatelly, none of the solutions worked for me :(

[@pankajsaini50]

Thank you Sir, Love from India 🙏

[@JaspreetKaur-od3gp]

Thank you. After so many vedios finally found the solution.😄

[@eleanortay7351]

Grateful for this amazing video. I have subscribed too. 😀👍

[@charlick2]

Thank you that was excellent

[@Tshiamo_Setshedi]

Thank you so much ! Very helpful man

[@shahrukhdhedhi6583]

Super Helpful! Thanks a lot.

[@Kxrena]

Very helpful! thank you!

[@kermstyson]

Hero video. Thank you.

[@Toohottorot]

THANK YOU!

[@joblack1838]

Dude thank you

[@romegracheve7647]

Thanks!

[@kwabalandautu2241]

Thanks alot

[@helmanfrow]

Any way to have an IF() statement return a true blank instead of an empty text string? Without VBA?