I was trying to use Kutools to DELETE personal identifiable information from a cell that contains various amounts of text. If KuTools cannot do this, can someone help me with a formula? I mainly want to delete email addresses from cells in a column(A). The cells contain many lines of text and some might contain more than 1 email address. The cell also contains email addresses that I do not want to remove, so I would need to add an exception rule to ignore 3 particular email addresses. Something like delete all email addresses in column A except these 3 email addresses. Is this possible? Any help would be appreciated.
There are no replies made for this post yet.