Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Create List box using this expression
=Replace(IF(WildMatch(Department,'D*'),Department),'D','Department ')
Create List box using this expression
=Replace(IF(WildMatch(Department,'D*'),Department),'D','Department ')
Hope this solves your problem.