Read one footnote code by its position
Turn AAN1 and position 2 into N1, never half of one code.
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | OR( … ) | Checks for an odd length or a position not there. | FALSE |
| 2 | "Review footnote position" | What the cell says when the position doesn't fit. | Not used for row 8 |
| 3 | MID(A8,2*B8-1,2) | Takes two characters, starting at code number B8. | "N1" |
| 4 | IF( … ) | Says Review unless the position is a whole code. | "N1" |
Each code is two characters, so position 2 starts at character 3.
=IF(OR(A8="",MOD(LEN(A8),2)<>0,B8<>INT(B8),B8<1,2*B8>LEN(A8)),"Review footnote position",MID(A8,2*B8-1,2))How to use it
Yellow bar at the top? Click Enable Editing.
- See it work. The Example tab shows 20 made-up examples with the formula already in.
- Use your own codes. Paste code runs and the position you want into the green columns of the Template tab. The codes fill in by themselves.
- Move them into your letter. Copy the results. Then use Paste Special and choose Values.
Before you send
Use this only for runs of two-character codes. Check any Review rows by hand.
Microsoft's help: MID function
OTHER ROUTES YOU MIGHT LIKE

Choose an HC ZIP+4 from box or route
HC 1 BOX 120 → 02108-4410 (box range, not route)
Get the template →
Keep the street from a health address
12 Oak St&Oak St&12 → 12 Oak St
Get the template →
Build a U.S. city-state-ZIP line
Boston + MA + 02108 → BOSTON MA 02108
Get the template →
Put the street back in an Address Block
Ava Reed, Boston → Ava Reed, 12 Main St, Boston
Take this route →