MrExlPWResetSucks
New Member
- Joined
- May 17, 2019
- Messages
- 1
Im trying to create a Spreadsheet Template that strips all encoding off of pasted information. Users will copy text and numbers from Web Pages into the Spreadsheet. It will not be feasable to train them on how to ensure they're copying plain text only, as simple as that should be. Microsoft Word allows you to setup this restriction in the "Options" section, but Excel does not have that apparently.
So how can I place restrictions into the Spreadsheet so when they paste, the encoding is stripped off AUTOMATICALLY and it just goes in as plain text or is reformatted to the format of the destination cells format?
So how can I place restrictions into the Spreadsheet so when they paste, the encoding is stripped off AUTOMATICALLY and it just goes in as plain text or is reformatted to the format of the destination cells format?