Breaking up a long string

Hi,
I have a table containing complete address in column A as per attachment. I would like to break it into two fields (Address1 and Address2), whereby the 1st half of the Address should come into the column Address1 and be "limited" to approx 25 letters. The rest of the address can go into Address2.

However, (obviously) the 25 letter limit should not break-up a word. Also, I cannot use a fixed width de-limiter since the addresses are all of variable length.

Help would be deeply appreciated. Thankx !

Hi Bitswit,

Perhaps try these formulas:

In B2: =IF(MID(A2,25,1)=" ",LEFT(A2,25),LEFT(A2,25+FIND(" ",A2,25)-25))

In C2: =RIGHT(A2,LEN(A2)-LEN(B2))

Hope that helps!