Excel Formula To Remove Ftp:// From Url In Analytics Event Text
Remove ftp:// prefix from URLs in analytics event text with a ready-to-use formula for Excel, Google Sheets, and WPS.
Quick answer
Unified formula
ExcelGoogle SheetsWPS
=IF(LEFT(A2, LEN("ftp://"))="ftp://", MID(A2, LEN("ftp://")+1, 999), A2)How it works
- Replace the sample range (like A2:A) with your real range.
- Keep the same column order used in the example.
- Fill down to apply the formula to every row.