Tech Support Guy banner

How to get MID unspecified count data of cell

802 Views 3 Replies 2 Participants Last post by  etaf
Hi,

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:
=RIGHT(A2,LEN(A2)-14)
Which gives me 'mid text'+(4 chars)
In a second column:
=LEFT(B2,LEN(B2)-4)

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

Thank you.
Status
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
Len(a2)-18


use a MID
=MID(A2,15,LEN(A2)-18)

Attachments

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