I got one requirement to trim the values. below is the requirement.
I have one column which values are displaying like this.
then I want to display the values as
I want to remove the WBG1 from the values.