Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- =IF( ISERR( FIND("-",Opportunity) ),
- "" & Opportunity,
- TRIM( MID( Opportunity, 1, FIND("-",Opportunity)-1 ) ) )
- =IF( ISERR( FIND("-",Opportunity) ),
- "" & Opportunity,
- TRIM( MID( Opportunity, FIND("-",Opportunity)+1, 999) ) )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement