When I export my database report to excel I lose any characters in cells which are over 255 characters. Please can anyone show me how to get around this?

Thanks

Which version of excel are you using?

Excel 2003 with SP2

In the query that selects the data for the report for any fields which have more than 255 characters change this from "group by" to "first" and you should get all the text from the field.