Check Contract Address Checksum
I need to check the last 4 characters of the contract address to verify against the documentation.
=RIGHT(A2, 4) How it works: The RIGHT function extracts a specified number of characters from the end of a text string. In this scenario, `A2` refers to the cell containing the full contract address, and `4` specifies that you want to extract the last four characters. This allows for quick and efficient verification of the contract address checksum against documented values.
Data Setup
| Contract Address | Documentation Checksum |
|---|---|
| 0x7Be8076f4df4A3edEa5B799fB06f49b42A60fE20 | fE20 |
| 0xAbC1234567890123456789012345678901234567 | 4567 |
| 0x1a2b3c4d5e6f7a8b9c0d1e2f3a4b5c6d7e8f9a0b | 9a0b |
Step-by-Step Guide
Enter your full contract addresses into column A, starting from cell A2.
In cell B2, type the formula `=RIGHT(A2, 4)`.
Press Enter to display the last 4 characters of the contract address from A2.
Drag the fill handle (the small square at the bottom-right of cell B2) down to apply the formula to all other contract addresses in column A.
Compare the extracted checksums in column B with your documentation to verify.