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 Remove Sftp:// From Url In Support Ticket Text

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

Remove sftp:// prefix from URLs in support ticket text with a ready-to-use formula for Excel, Google Sheets, and WPS.

Remove sftp:// from url in support ticket text.

ExcelGoogle SheetsWPS

=IF(LEFT(A2, LEN("sftp://"))="sftp://", MID(A2, LEN("sftp://")+1, 999), A2)

Remove https:// prefix from URLs in transaction text with a ready-to-use formula for Excel, Google Sheets, and WPS.

Remove http:// prefix from URLs in transaction text with a ready-to-use formula for Excel, Google Sheets, and WPS.

Remove ftp:// prefix from URLs in transaction text with a ready-to-use formula for Excel, Google Sheets, and WPS.

Remove sftp:// prefix from URLs in transaction text with a ready-to-use formula for Excel, Google Sheets, and WPS.

Remove https:// prefix from URLs in imported csv text with a ready-to-use formula for Excel, Google Sheets, and WPS.

Remove http:// prefix from URLs in imported csv text with a ready-to-use formula for Excel, Google Sheets, and WPS.