Hi all,

I like to be able to obtain the dates in a text format from the table
below. ie
Test2 8-Feb
Test5 4-Feb,8-Feb
Test6 4-Feb,5-Feb, 9-Feb

Do I need to do this by macros and if so, any help would be appreciated.

Table
Care Recipient Surname 4-Feb 5-Feb 8-Feb 9-Feb

Test1
Test2 8-Feb
Test3
Test4
Test5 4-Feb 8-Feb
Test6 4-Feb 5-Feb 9-Feb