Category: Len

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

Formula to get first name from 2 formats either (Lastname, First) or (Firstname Last) formats....

I often use the technique of concatenating columns into 1 cell with separators. Something like the CSV, 1 line that has all values for a...

Found this in an old file while doing some digital cleaning This will show you how you can easily count how many times a letter...