Hopefully this is in the realms of the possible. I have a managed metadata column. I wanted this to allow multiple selections and through a workflow I've copied the column to another for use in filtering.
This of course brings in all the crud. So my clothing column turns into:
I then use a calculated column to remove the "pipe" character:
Which leaves me just with Clothing. Great. Unfortunately when using multiple selections it breaks. If I chose more than one and get this:
My formula just keeps the Clothing part. Is there a way of this formula removing the | and keeping my metadata? So it turns this: