Problem in formula

[SanjayaGarg]

Dear all,

I am having following data in A column :
A B C D E

13-00-012345-000-1214​	=SUBSTITUTE(A1, "-", "")​	13000123450001214​	=IF((SEARCH("13-00-", A1)), (MID(A1, 7, 6)), C1)​	012345​
13-59-005619-210-1001​		13590056192101001​		#VALUE!​

Formula in B column, gives result as in C which is ok. Formula in column D is working fine if column A contains "13-00-" but if it contains any value after 13- then its not functioning. In that case I want it to return value in column C. Kindly help.

 

[Fluff]

How about

+Fluff 1.xlsm
	A	B	C
1
2	13-00-012345-000-1214	13000123450001214	012345
3	13-59-005619-210-1001	13590056192101001	13590056192101001
Master

Cell Formulas
Range	Formula
B2:B3	B2	=SUBSTITUTE(A2, "-", "")
C2:C3	C2	= IF(ISNUMBER(SEARCH("13-00-", A2)), MID(A2, 7, 6),B2)

 

[SanjayaGarg]

How about

+Fluff 1.xlsm
	A	B	C
1
2	13-00-012345-000-1214	13000123450001214	012345
3	13-59-005619-210-1001	13590056192101001	13590056192101001
Master

Cell Formulas
Range	Formula
B2:B3	B2	=SUBSTITUTE(A2, "-", "")
C2:C3	C2	= IF(ISNUMBER(SEARCH("13-00-", A2)), MID(A2, 7, 6),B2)

Thanks. It is working now.

 

[Fluff]

You're welcome & thanks for the feedback.