Help in Excel 2007

[Luiz]

Hi,

I need a help in Excel 2007.
I have a document that has, for example, in line A1 a Group Data (text) and
the A2, A3, A4, A5 his user:
Security - Carl - Richard - Raymond - Mary
And I woud like to agragate the A2, A3, A4 and A5 in another row.
Is there a formula tho do that?

Thanks.

Luiz

 

[Roger Govier]

Hi Luiz

=A2&", "&A3&", "&A4&", "&A5

Replace the comma space within the quotes with whatever separator you want,
for example " - "

 

[Luiz]

Hi Roger,

Thank you very much for your help.
It was very helpful.

Best Regards.

Luiz