Read one footnote code by its position

Turn AAN1 and position 2 into N1, never half of one code.

What you'll make

In Excel: AAN1 + 2 becomes N1.

The formula

The formula, with a numbered bracket under each part.
NumberPartWhat it doesResult so far
1OR( … )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
3MID(A8,2*B8-1,2)Takes two characters, starting at code number B8."N1"
4IF( … )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.

  1. See it work. The Example tab shows 20 made-up examples with the formula already in.
  2. 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.
  3. 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