To get the LEFT part:
formula in B1 and copy down
Formula: copy to clipboard 
=SUBSTITUTE(LEFT(A1,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A1&1/17))-1),",","")

v A B
1 Loga Square East,27 Franklin Town Blvd Apt 1103 Loga Square East
2 Londonbury Homes Inc 432 Jane St Londonbury Homes Inc