Getting out numbers

[vmjan02]

I have this table and it takes around 5 hrs to complete the task, not sure as wh to get the out put. tried multipal ways but no luck, any formula to fix it.

Data	Result in Text
CoreNCS8-MRSTRDEF-1 Hu0/4/0/25 Link Monitoring PRN 116933***	0/4/0/25
MetroCore-PTX5K-Abar-422-1 et-7/1/7**	7/1/7
MetroCore-PTX5K-Bur-601-1 et-7/1/9** //High-Latancy Link offloaded in upload direction	7/1/9
PE-AggX16A-Abha-701-2 Gi3/0/11 **	3/0/11
PE-AggX16A-Kham-702-1 Gi16/1/10 **	16/1/10
PE-AggX16A-Abha-701-2 Gi4/1/10 **	4/1/10
PE-AggX16A-Kham-702-1 Gi3/0/11 **	3/0/11
PE-Agg22-Hut-111-5 Te 0/1/0/11 **	0/1/0/11
PE-AggX16-Bil-711-1 Gi1/0/6 ** METRIC-RAISED IN-UPLOAD-DIRECTION	1/0/6
PE-AggX16-Bil-711-1 GigabitEthernet1/0/4**	1/0/4
PE-AggX16-Bil-711-1 GigabitEthernet2/0/3**	2/0/3
PE-AggX16-Bil-711-1 Gi1/0/10 **	1/0/10
PE-AggX16-Bil-711-1 Gi1/0/11 **	1/0/11
CoreNCS-Baha-712-1 TenG 0/6/0/8**	0/6/0/8
CoreNCS-Baha-712-1 TenG 0/6/0/24**	0/6/0/24
CoreNCS-Abha-701-1 Te0/6/0/45**	0/6/0/45
CoreNCS-Abha-701-1 TenG 0/6/0/48**	0/6/0/48
PE-Agg22-Mar-231-5 Interface Te0/0/1/9**	0/0/1/9

 

[vmjan02]

yes you are right yellow color should be 16/1/10 and not 6/1/10. row 6.

 

[Peter_SSs]

should be 16/1/10 and not 6/1/10

That's why I was asking you to fill in the expected results manually - such a mistake would have bee much less likely.

Try this

With Worksheets("Working Sheet")
  .Range("G1").Value = "IfAlias Remort Interface"
  With .Range("G2:G" & .Range("A" & .Rows.Count).End(xlUp).Row)
    .Formula2 = "=LET(c,MID(B2,SEQUENCE(LEN(B2)),1),s,CONCAT(IF(ISNUMBER(-c),c,IF(c=""/"",c,REPT("" "",100)))),TRIM(MID(s,FIND(""/"",s)-50,100)))"
'    .Value = .Value
  End With
End With

 

[vmjan02]

Thanks for the extra sample data ... BUT ... you didn't ever do this ..

... and so now I cannot understand what the logic is as to why the leading digit "1" is not included in the wanted result in row 6 (see yellow below) but the leading digits "10" are included in the wanted result in row 24 (green).

View attachment 101972

@Peter_SSs

Yes you are very very right, it has to be 16/1/10. Sorry for the trouble as its a lot of manula working so this errors hve occred, have take the team left and center for the incorrect data.
I have mysleft dot eh data this time and colour yellow as well.

Thank you God for a person like Peter like an angle and help out, thabk you once again.

 

[Peter_SSs]

You're welcome. Glad we got there in the end.