exporting to excell problem

[KM]

when I export address field to excell spreadsheet, a carrige return symbol appears between the address information. Is there any way around this?

Thanks

[danjacoby]

quote:

---

Originally posted by KM:

when I export address field to excell spreadsheet, a carrige return symbol appears between the address information. Is there any way around this?

Thanks

---

If you want the whole address in one cell in Excel (and it appears that way), create a calc:

Substitute (Address, "

[Alan Betts]

The above method will also remove unwanted returns at the end of any field that should not have returns on them.

Having dealt with so many typo problems on export, I now create many of the fields to be exported, especially addresses as calcluations. It is far easier to control the exported result and eliminate a lot of user errors.

e.g. for a one line address to be concatenated from Address, Town 'n' Post Code fields

If(IsEmpty(Address;"";Substitute(Address;"