Hi All, Is there a way to “scramble” text in an Excel column? I have some “real” data that I want to use for a demo, but I don’t want people to see the last names in the data. Thank you. -Rick
You can use the Hash transform using one of the MD5 algorithms. But it does make text longer. So perhaps also use Extract to shorten.
Or use Replace and a regex to replace each character with an asterisk.