Help with Parsing String with MID

[tbruce]

Hi all,

Looking for a little help with this formula. My formula doesn't seem to work properly due to the "-" being used.

I'm trying to extract the first four digits between "(DRILL-1) " and "-" (e.g.4106 and 4108) and place into column B and then from the "-" to the end of the digits (e.g. 20692 and 5434) into column C using formulas.

Any help with a formula would be appreciated.

[TABLE="class: grid, width: 700"]
<tbody>[TR]
[TD][/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]C[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: center"]Serial Number[/TD]
[TD="align: center"]Make[/TD]
[TD="align: center"]Model[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]NFPC1193R_RyLAPi (DRILL-1) 4106-20692[/TD]
[TD]4106[/TD]
[TD]20692[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]NFPC1193R_RyLAPi (DRILL-1) 4108-5434[/TD]
[TD]4108[/TD]
[TD]5434[/TD]
[/TR]
</tbody>[/TABLE]

 

[Michael M]

Maybe this

Excel 2007
	A	B	C	D
1	Serial Number	Make	Model
2	NFPC1193R_RyLAPi (DRILL-1) 4106-20692	4106	20692
3	NFPC1193R_RyLAPi (DRILL-1) 4108-5434	4108	5434
4
5
Sheet1

Cell Formulas
Range	Formula
B2	=MID(A2,SEARCH(") ",A2)+2,4)*1
B3	=MID(A3,SEARCH(") ",A3)+2,4)*1
C2	=TRIM(RIGHT(SUBSTITUTE(A2,"-",REPT(" ",LEN(A2))),LEN(A2)))*1
C3	=TRIM(RIGHT(SUBSTITUTE(A3,"-",REPT(" ",LEN(A3))),LEN(A3)))*1

 

[tbruce]

That worked - thank you very much!

 

[Michael M]

Glad to help...