Help in Excel 2007
 

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

Help in Excel 2007
 

Hi Luiz

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

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

--
Regards
Roger Govier

"Luiz" wrote in message
...
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

Help in Excel 2007
 

Hi Roger,

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

Best Regards.

Luiz

"Roger Govier" wrote:

Hi Luiz

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

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

--
Regards
Roger Govier

"Luiz" wrote in message
...
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