# SolvedHow to get MID unspecified count data of cell

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

#### estyMonsty

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.

#### etaf

Wayne
Moderator
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

• 8.5 KB Views: 0

#### estyMonsty

Perfect!! Exactly what I wanted, thank you.

#### etaf

Wayne
Moderator
you are welcome

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

As Seen On

### Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

over 807,865 other people just like you!