Maintain format of currency and or date whent cocantenating data

Hello John,

As I thought, Concatenate can only handle text but you can "translate" your currency and date data by using the Text function which combines a reference to the cell which contains the data with a currency / date picture (such as we use in Custom formatting) enclosed in " " to make it text.

Please see attached the test file I have put together for you.

C4 contains the main Concatenate function, the currency formatted data is in A6 with its Text function (referred to in the main formula) in C6. The formatted dates are in A8 and A10 with their Text functions in C8 and C10 respectively.

I leave it to your own judgement to decide if this solution still constitutes "lazy" report writing!

Kind regards,

Ruth