Concatenating cells (1 Viewer)

T

trebor3900

Registered User.

Local time

Today, 17:03

Joined

Apr 26, 2005

Messages

47

• Aug 13, 2008

• #1

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

 

S

shades

Registered User.

Local time

Today, 11:03

Joined

Mar 25, 2002

Messages

516

• Aug 14, 2008

• #2

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?

 

maxmangion

AWF VIP

Local time

Today, 17:03

Joined

Feb 26, 2003

Messages

2,805

• Aug 14, 2008

• #3

you can also use the concatenate function i.e.

=Concatenate(A1, ", ", B1)

 

N

namliam

The Mailman - AWF VIP

Local time

Today, 18:03

Joined

Aug 11, 2003

Messages

11,695

• Aug 14, 2008

• #4

trebor3900 said:

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.

Click to expand...

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

 

T

trebor3900

Registered User.

Local time

Today, 17:03

Joined

Apr 26, 2005

Messages

47

• Aug 18, 2008

• #5

Thanks guys worked a treat.

 

maxmangion

AWF VIP

Local time

Today, 17:03

Joined

Feb 26, 2003

Messages

2,805

• Aug 19, 2008

• #6

you're welcome