ExcelBanter - Obtain Middle vlaue of text with unknow length

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Obtain Middle vlaue of text with unknow length (https://www.excelbanter.com/excel-worksheet-functions/241790-obtain-middle-vlaue-text-unknow-length.html)

Abdul Shakeel[_2_]

Obtain Middle vlaue of text with unknow length

Hi,

I have many cell with values like
01/ab123/09
01/123A/09
1/1A/9
I want to extract the middle value of each cell how could I do This.

Gary''s Student

Obtain Middle vlaue of text with unknow length

=LEFT(RIGHT(A1,LEN(A1)-FIND("/",A1,1)),-1+FIND("/",RIGHT(A1,LEN(A1)-FIND("/",A1,1))))

--
Gary''s Student - gsnu200902

T. Valko

Obtain Middle vlaue of text with unknow length

Try this:

=MID(A1,FIND("/",A1)+1,FIND("/",A1,FIND("/",A1)+1)-1-FIND("/",A1))

--
Biff
Microsoft Excel MVP

"Abdul Shakeel" wrote in message
...
Hi,

I have many cell with values like
01/ab123/09
01/123A/09
1/1A/9
I want to extract the middle value of each cell how could I do This.

Teethless mama

Obtain Middle vlaue of text with unknow length

=TRIM(MID(SUBSTITUTE(A1,"/",REPT(" ",99)),99,99))

"Abdul Shakeel" wrote:

Hi,

I have many cell with values like
01/ab123/09
01/123A/09
1/1A/9
I want to extract the middle value of each cell how could I do This.

All times are GMT +1. The time now is 07:14 AM.