Cells with additional spaces
August 4, 2022
Detect which cells has additional spaces added by mistake by user.
=IF(AND(Left(F2, 2) = "No", LEN(F2) >2, "Space at end", "")
This was needed in some of my tutorials with a student, they had some users adding spaces at end, that cannot be detected easily. Sharing formula here.
Excel Dynamic Drop-Downs that grow with you
Insert Blank rows into table using functions
Multiple Dual-Validations
About The Author
ANmar
An Excel-Passionate user, developer and teacher Love finding new ways to solve daily issues and enhances to regular users, then teach that