Hi All

I have a cell with the following text

251 High St Kangaroo Flat VIC 3555

Using a formula How to i divide it up at the thrid word so that in one
cell is

251 High St
and in the other is
Kangaroo Flat VIC 3555

I have a lot of address and need to mail merge them into word

Thanks

Andrew


--
koba
------------------------------------------------------------------------
koba's Profile: http://www.excelforum.com/member.php...o&userid=28639
View this thread: http://www.excelforum.com/showthread...hreadid=529904