In one cell, I am trying to create a formula to take the mid length of text (where the mid length changes but the left and right characters either side do not i.e. (14 chars)+'mid text'+(4 chars).
e.g. AR5555-dwg-Public Domain Interface - Context Plan.dwg
All I have come up with is...