PLEASE EXCUSE MY NOT FOLLOWING PROPER PROTOCOL FOR SHOWING MY EXAMPLE, I AM
IN A HURRY AND IT IS MORE LOGICAL TO ME THIS WAY:

=IF(LEN(D1855)<=17,IF(LEN(B1855<=7),IF(FIND("STE", B1855,1),CONCATENATE(D1855," ",B1855))),"")

Column A contains LEN(B1855) (EXCEL returned value 8)
Column C contains LEN(D1855) (EXCEL returned value 17)
Column B and D are simple data (text)

A B C D E

8 STE 1234 17 123 S CENTRAL AVE 123 S CENTRAL AVE STE 1234

I am tracking field length as I revise a huge database (30k rows of customer
data) and only have 25 CHAR fields to work with when I upload back to our
Company Database program

PROBLEM: I should be getting a FALSE result, because the LEN of Column B IS
NOT <=7, it is 8. Yet, the formula continues to the end. When it Concats, I
end up with 26 characters in Column E.

Thank you! Melinda