Thanks for this Earl,

My database has already been set up with the address in one field and it
would be very complicated to change this now.

I have been sent a load of data which I have formatted in Word.

Here is an example:

Zinc Unit U20
Acton Business Centre
School Rd
Old Oak Common
London NW10 6TD 020 8838 3636

In order to split the data into separate fields I have placed a tab after
the company name, manual line breaks between the address lines, a tab before
the postcode and a tab before the telephone number. But Excel doesn't
recognise the line breaks. So I've replaced the line breaks with commass so
as to keep the address in one field when importing using tabs as the
delimiters. But I then want to pull the data into Filemaker and would like to
find a way of replacing the commas with line breaks.

I suppose you may be right that if I put all the address lines into separate
fields and then used a formula to join them together that might be the way to
go, but I still can't work out how to get the line breaks in!

Any other thoughts?

Sue