Substitute ( Field2 ; "Gross" ; "" )
This calculation worked and did what I needed it to do. But when updating the field where I want to use this became more complicated than I thought. I currently have a layout that is set and do not want to change the fields that are in this layout and portals. I made a copy of this layout and wanted to modify it to show slightly different info. I'm going to upload a few images, so if you can wait until I post them all before responding, would appreciate it. These images will show how the portal is currently set up and one image will explain what info. I want displayed in the portal. Basically, for only department names that have "combo pad" listed on left side in this first image, in the portal next to it, I want to be able to select the department names that are included in the combo pad. Which will have at least 2 or more departments that need to be listed in the portal. The "after" image shows that I've selected "Gross Juniors", but this is where the substitute calculation comes into play, where I only want it to read, "Juniors". And this is only for this layout. The original layout that I copied this from, should not be affected with these changes that I want to make. I'm going to try and provide all the images that I think you would need to see on how this original portal was set up (not by me), which is why I'm not sure how to get this to work. Thanks for your help and patience with me.
This is the last image. If you need me to provide anything else to help you with this, just let me know.
I'm not sure that I'd use a calculation field at all for this. I'd need to know a lot more about the design and intended function of your database, but there's a good chance that I'd use a related table to match records with specific text such as "Juniors" with records that have "combo Pad" entries in them.
Your second screen shot shows a design error that will result in problems on your layout. The ::DepartmentName field is not place where it can work with this portal. It looks like your portal rows would need to be reduced and then made taller so that both fields under the "department" label fit inside a single row of the portal.
To use the calculation field approach, you could do this:
If ( PatternCount ( LefthandFieldHere ; "combo pad" ) ; Substitute ( FieldInPortalHere ; "Gross" ; "" ) ; FieldInPortalHere )
The original layout that I copied this from, should not be affected with these changes that I want to make
But these changes take place in the records of a table which are then displayed on your layouts. To keep the changes from affecting your original layout, you'll need two fields, one that makes this change and one that does not so that you can use both fields on different layouts.