Encrypting cell content

S

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
 
J

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.
 
S

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
 
Top