Extracting Numbers after a Dash

[PhancyK]

Hey,

I'm trying to expand on the code =REPLACE(AR5,1,FIND("-",AR5),"") into an array that can gather multiple numbers from F5:AR5. The problem is that those cells can contain other values that don't include a dash.

Cells F5:AR5 can include:
empty
D
N
T
DOT-1
NES-1
TYL3ES-1
FDR3

and multiple other combinations. I just need something to return and add any numbers that come after the "-"

Is there anyway to do this with a single code?


Thanks

 

[Scott Huish]

=IFERROR(REPLACE(AR5,1,FIND("-",AR5),""),"")

Copy down.

 

[PhancyK]

Ok, so that gets rid of the error caused by the cells with different values but how do I create an array across 35 cells?

Basically shorten:

=IFERROR(REPLACE(F5,1,FIND("-",F5),""),"0")+(IFERROR(REPLACE(G5,1,FIND("-",G5),""),"0")+(IFERROR(REPLACE(H5,1,FIND("-",H5),""),"0"))) and so on...

 

[AhoyNC]

Maybe something like this:
This is an array function and must be entered with

Excel Workbook
	G	H	I	J	K	L	M
3	57
4
5	df- 4	dr-45		t-2		zr- 6
CTRL-SHIFT-ENTER.

 

[PhancyK]

Amazing.

Thank you so much.