mercredi 1 avril 2015

How to apply a REGEX to an entire column in Google Spreadsheets?

Say for example in column C I have all emails which contain the same domain. This field is populated by a form.


I need a function to remove the @domain.com from the field every time a new record is inserted in the column.


pseudo code:



=REGEXREPLACE(<this-cell-value>,"@domain.com","")

Aucun commentaire:

Enregistrer un commentaire