Editing text with calculated result
I'm sure there is a way to do this, but can't seem to figure out the correct calculation to have this work. I currently have two fields. One that shows text such as, "Gross Mens" and I have another field where I want to have a calculated result to remove the word, "Gross" and just have it be shown as "Mens". But I don't want the first field to change, which is why I created the second field. What's the calculation for this to remove certain text, such as this example of "Gross"? Thanks.