Skip to Content
0
Former Member
Apr 27, 2009 at 04:48 PM

Concatenating the strings

21 Views

Hello All,

Pls suggest me something for the problem I am facing below.

I have 2 columns(Manager ID and Dept Name)

Data

Manager ID as 1 and Dept name as A

Manager ID as 1 and Dept name as B.

I want to display as Manager ID 1 andDeppt name A,B

I have written a formula but the result i ma getting is

Manager ID 1 and Dept name A

Manager ID 1 and Dept name A,B

please suggest how can i avoid getting 'Manager ID 1 and Dept name A'

and get only 'Manager ID 1 and Dept name A,B'

Thanks Robinn