extract the product name

[Cherkos12]

Hi -

My data includes a combined field containing both opportunity and product names. I need to extract the product name and remove the opportunity name. what formula should i use?

SFDC Oppty ID	Oppty Name	Prod Code	Prod Name
0063m00000qTkpxAAC	Renewal for Contract #00005577	SPS-P-0001	Renewal for Contract #00005577 SPOS Subscription
0063m00000qUcwGAAS	Renewal for Contract #00044611 - Yakira Ltd - SPOS - M/Y ICE	SPS-P-0001	Renewal for Contract #00044611 - Yakira Ltd - SPOS - M/Y ICE SPOS Subscription
0063m00000qU02PAAS	Renewal for Contract- Meteofeed 2024 #00005653	DFA-P-00006	Renewal for Contract- Meteofeed 2024 #00005653 Advanced Weather Data Premium Enterprise Edition Meteofeed

[ChrisTX · Accepted solution]

Use a Formula tool

Replace([Prod Name], [Oppty Name], "")

[SPetrie · Accepted solution]

Assuming the Oppty Name is always exact in the Prod Name column, you should be able to use this

trim(replace([Prod Name],[Oppty Name],""))

[Cherkos12]

 @ChrisTX @SPetrie thank you both, that worked.