Changing and limiting values in listbox (dynamically)

[retko1985]

Hello,

I have this data in column / listbox:

What I want is to replace each D with word 'Department ', so it will be 'Department 1' instead of 'D1'. And I also want to remove the values N and TOTAL, so I will have only Department values in a listbox.

I need it dynamically, since i don't know how many departments I will have.

Can someone help me?

Thank you.

[MK_QSL · Accepted solution]

Create List box using this expression

=Replace(IF(WildMatch(Department,'D*'),Department),'D','Department ')

[saimahasan]

Hope this solves your problem.