Detect which cells has additional spaces added by mistake by user. =IF(AND(Left(F2, 2) = "No", LEN(F2) >2, "Space at end", "")...