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