Hi

When concatenating data in Excel 1997-2003, I used to be able to separate pieces of data using char(10)......and that would effectively put in a carriage return - this made data display quite neatly, especially when text was imported into Desription fields in CRM systems for example:

eg: =concatenate(A2,char(10),B2,char(10),C2) might look in real data like:

Customer=Yes
Reference Customer=No
Named Account=Yes

which is neater than using something like a semi-colon....eg.

Customer=Yes; Reference Customer=No; Named Account=Yes

Anyway, I don't seem to have any luck using my old char(10) routine in Excel 2007. Does anyone know how I can make this work again?

Thank you
Wendy