Hi. I looking for a formula that will return text to the right of the 2nd pipe.

MZED

Customer Success | Team Meeting | ACS-1

Development | QR Codes | TD-1006

Cross| PWA | XTNXB-7

This text is from the dropdown, which has about 30 different options. I made the text that must be returned bold

Thanking you

Paul H

Try this

=RIGHT(Text@row, LEN(Text@row) - FIND(CHAR(124), Text@row, FIND(CHAR(124), Text@row) + 1) - 1)

Paul H

Try this

=RIGHT(Text@row, LEN(Text@row) - FIND(CHAR(124), Text@row, FIND(CHAR(124), Text@row) + 1) - 1)

MZED

Thanks so much Paul.

It worked !