Can I use this in Google Sheets or WPS?

Yes. Use the Sheets or WPS version shown below. Adjust ranges to match your sheet.

Formula Library

Excel Formula To Extract Segment 3 By Pipe In Webhook Payload Text

Paste the formula into the first output cell, then fill down to apply it to your range.

Extract segment 3 split by pipe in webhook payload text with a ready-to-use formula for Excel, Google Sheets, and WPS.

Extract segment 3 by pipe in webhook payload text.

ExcelWPS

=INDEX(TEXTSPLIT(A2, "|"), 3)

View platform differences

=INDEX(SPLIT(A2, "\|"), 3)

Extract segment 2 split by comma in transaction text with a ready-to-use formula for Excel, Google Sheets, and WPS.

Extract segment 3 split by comma in transaction text with a ready-to-use formula for Excel, Google Sheets, and WPS.

Extract segment 4 split by comma in transaction text with a ready-to-use formula for Excel, Google Sheets, and WPS.

Extract segment 2 split by dash in transaction text with a ready-to-use formula for Excel, Google Sheets, and WPS.

Extract segment 3 split by dash in transaction text with a ready-to-use formula for Excel, Google Sheets, and WPS.

Extract segment 4 split by dash in transaction text with a ready-to-use formula for Excel, Google Sheets, and WPS.