Solved How 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

Thread Starter
Joined
Mar 22, 2017
Messages
23
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
Joined
Oct 2, 2003
Messages
65,487
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

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.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
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.

Join over 807,865 other people just like you!

Latest posts

Top