Encrypting cell content

[Simon L]

I wonder if someone can help me with this. I need to encrypt cell content,
specifically member identification #.

In my spreadsheet, I have a column called Member # which is a text field, I
need to encrypt these member #s and assign a different value yet all other
records will still relate to the same member with the same member #.

Thanks

Simon

 

[Jim Thomlinson]

I am not 100% sure what you mean by encrypt. That being said you need to
understand that XL is not a secure platform and any type or encryption that
you add can be broken.

 

[Simon L]

Jim,
Thanks for the response. May be encrypt is not the right term for it. Let me
explain, I need to provide a client with a spreadsheet of member records but
the I don't want to provide members' SSN.

I want to convert member # to a random and different value. The new value
must maintain a uniqueness to that member and his/her records. Let say the
member SSN is 123-45-6789. I need to convert that to a random value, say
4584. Then all records assoicate with 123-45-6789 will now associate with
4584. The original SSN will be deleted before I send to the client.

Hope this clarifies my intention.

Simon

 

[Bob I]

Perhaps Sort on the SSN and then replace with a straight incrementing
value.