How to Get Number Between Slash "/"

[krunal123]

Between two Slashs "/" Or
Two and more Slashs how to work formula in this condition

 

[Toadstool]

Hi Krunal123,

Does this work for you?

Krunal123-v2.xlsx
	A	B	C	D
1	Invoice No.			Result
2	EXP/052/20-22			052
3	Dog/88/2-2-2-2			88
4	Goats/888/66/66/99			888
5	A/1/A			1
6	INV/12345///			12345
7	a/2			Two / not found
Sheet2

Cell Formulas
Range	Formula
D2:D7	D2	=IFERROR(MID(A2,FIND("/",A2)+1,FIND("/",A2,FIND("/",A2)+1)-FIND("/",A2)-1),"Two / not found")

 

[Phuoc]

Or try:

=TRIM(MID(SUBSTITUTE(A2,"/",REPT(" ",200)),200,200))

 

[Peter_SSs]

If your data is as uniform as those 7 samples, all you would need is

=MID(A2,5,3)

 

[James Clear]

View attachment 44339

Between two Slashs "/" Or
Two and more Slashs how to work formula in this condition

or maybe

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