Tech Support Guy banner

How to get MID unspecified count data of cell

802 Views 3 Replies 2 Participants Last post by  etaf

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[1]-Public Domain Interface - Context Plan.dwg

All I have come up with is:
Which gives me 'mid text'+(4 chars)
In a second column:

Is there a way of creating a formula combining the two in one column?

Thank you.
Not open for further replies.
1 - 4 of 4 Posts
you know you want to start at character 15
and you want the MID section which is the length of the cell - 18 (14+4) characters

use a MID


Perfect!! Exactly what I wanted, thank you.
you are welcome
1 - 4 of 4 Posts
Not open for further replies.