I have a table imported to a spreadsheet from Access containing a duty and a staff number

DUTY STAFFNO
Rest Day 123456
Rest Day 234567
Annual Leave 345678
Earlies 456789
Earlies 567891
Lates 678967

I need to concatenate the Staffno's for each Duty, delimited by a comma, into another worksheet cell dependant on the duty.

Any help would be gratefully recieved

Howdy. Assume duty is in Col A and StaffNo in Col B and each starts in row 2. In Col C2, put this formula:

=A2&","&B2

Copy down as appropriate.

Is that what you are wanting?

you can also use the concatenate function i.e.

=Concatenate(A1, ", ", B1)

I have a table imported to a spreadsheet from Access containing a duty and a staff number

...
I need to concatenate the Staffno's for each Duty, delimited by a comma, into another worksheet cell dependant on the duty.


Sounds to me like you need to export from the DB a comma seperated file instead of an excel sheet.

Thanks guys worked a treat.

you're welcome :)