Hi, I have some addresses that need to be split into three different cells: Adress, Zip, and City. I tried =TRIM(LEFT(SUBSTITUTE(D2;",";REPT(" ";LEN(D2)));LEN(D2))) to get the address, worked fine for those with the form: xyzroad 16A, 1400 townXYZ. But when I have it in the form XYZ, XYZroad 18...