Extract Diagnosis Sub-Code
I need the last 3 digits of the ICD-10 code to determine the specific severity of the diagnosis.
=RIGHT(A2,3) How it works: The RIGHT function extracts a specified number of characters from the end (right side) of a text string. In this scenario, `A2` refers to the cell containing the full ICD-10 code, and `3` indicates that you want to extract the last three characters. This allows medical coders to quickly isolate the specific sub-classification or severity indicator from the complete ICD-10 code for analysis or reporting.
Data Setup
| ICD-10 Code | Extracted Sub-Code |
|---|---|
| S06.0X0A | X0A |
| M10.011 | 011 |
| G40.401 | 401 |
| E11.9 | 1.9 |
| J45.909 | 909 |
| I10 | I10 |
Step-by-Step Guide
Select the cell where you want the extracted sub-code to appear (e.g., B2).
Type `=RIGHT(` into the formula bar.
Click on the cell containing the full ICD-10 code (e.g., A2).
Type `,3)` to specify that you want to extract the last 3 characters from the right of the code.
Press Enter to apply the formula.
Drag the fill handle (the small square at the bottom-right of cell B2) down to apply the formula to the rest of your ICD-10 codes.