vendredi 21 décembre 2018

random string search in google sheet or excel ?

I have excel file for different big data, I am cleaning this data and want to remove random string which ends by C"

ex: hC7cP41nSMkC" aqlVkmm33-oC" j3f4tGmQtD8C" blknAaTinKkC"

and so on, I want regular expression code to search for any random string end by C" and replace it by empty content by look find and replace.

I am not sticking with excel, I am opened to code steps I can use to do this

i need help

Thanks




Aucun commentaire:

Enregistrer un commentaire