Extract Gas Fee Gwei
As a Blockchain Developer, I need to extract the last 2 digits of the 'Gas Price' value from my transaction logs to analyze micro-fluctuations in Gwei. This helps me optimize gas strategies and understand network congestion patterns at a very granular level.
=RIGHT(B2,2) How it works: The RIGHT function extracts a specified number of characters from the end of a text string. In this scenario, `B2` refers to the cell containing the 'Gas Price (Gwei)' value (e.g., '25.12'). The number `2` tells Excel to extract the last two characters from that string. This effectively isolates the decimal part of the Gwei value, allowing the Blockchain Dev to focus on the micro-fluctuations (e.g., '12' from '25.12', '05' from '30.05').
Data Setup
| Transaction ID | Gas Price (Gwei) |
|---|---|
| TX001 | 25.12 |
| TX002 | 30.05 |
| TX003 | 28.99 |
| TX004 | 27.00 |
| TX005 | 31.55 |
| TX006 | 29.07 |
Step-by-Step Guide
Open your Excel spreadsheet containing the blockchain transaction data.
Locate the column with 'Gas Price (Gwei)' values (e.g., Column B).
Select an empty cell in a new column where you want the extracted digits to appear (e.g., C2).
Type the formula: `=RIGHT(B2,2)` and press Enter. (Assuming B2 contains the first gas price value).
Drag the fill handle (the small square at the bottom-right corner of cell C2) down to apply the formula to all relevant rows in your dataset.