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 Www. From Domain In Transaction Text

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

Remove www. from domains in transaction text with a ready-to-use formula for Excel, Google Sheets, and WPS.

Remove www. from domain in transaction text.

ExcelGoogle SheetsWPS

=SUBSTITUTE(A2, "www.", "")

Remove m. from domains in transaction text with a ready-to-use formula for Excel, Google Sheets, and WPS.

Remove store. from domains in transaction text with a ready-to-use formula for Excel, Google Sheets, and WPS.

Remove www. from domains in imported csv text with a ready-to-use formula for Excel, Google Sheets, and WPS.

Remove m. from domains in imported csv text with a ready-to-use formula for Excel, Google Sheets, and WPS.

Remove store. from domains in imported csv text with a ready-to-use formula for Excel, Google Sheets, and WPS.

Remove www. from domains in crm export text with a ready-to-use formula for Excel, Google Sheets, and WPS.