Changing Numbers for security purposes

[CONFUSED_AS_USUAL]

Hi,

I have tens of thousands of item numbers. At time I need to circulate spreadsheets that contain them. However, there are times where I do not want people or organizations to know these exact item numbers.

Is there some tool, function or script that can change these item numbers to another item number in a batch form ?


Thanks,

 

[CONFUSED_AS_USUAL]

To clarify - It would have to be consistent.

IE:

Original # ABC123 - New Number would be XYZ789

Another original # 123 would be 789.

In other words, it has to be scrambled code.

 

[DanteAmor]

Do you want a kind of encrypt the data?

 

[CONFUSED_AS_USUAL]

Do you want a kind of encrypt the data?

Yes, encrypt is a much better word.

 

[DanteAmor]

Check some link about encryption, example:

http://www.vbaexpress.com/kb/getarticle.php?kb_id=951

https://www.mrexcel.com/forum/excel-questions/923404-how-encrypt-numbers-excel.html

 

[CONFUSED_AS_USUAL]

Thanks !

 

[DanteAmor]

Youre welcome & thanks for the feedback.