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
Bookmarks