how to find hyphen from 12-12-123

[dummies]

hello friends
help me with vba code to
1.find hyphen (12-12-123)
2. split into 3groups
3.check if they are numeric ( group)
4. find the length of group

thank you very much

 

[Peter_SSs]

Does it have to be with vba?

Can you show us how the result(s) should be shown?

Better still, can you show us a variety of input data (it sounds like sometimes it might not all be numeric), preferably with XL2BB so we can copy/paste to test with and include the expected results?

 

[Zot]

I think you have similar interest as this

Excel Formula - How to extract values between commas?

example RANGE (A1) : AA, BB, CC, DD, EE, FF, GG, HH TARGET (B1) : AA (B2) : BB (B3) : CC (B4) : DD (B5) : EE (B6) : FF (B7) : GG (B8) : HH I made second part, but after second, i do not know how to make it... =MID(A1,FIND(",",A1)+1,FIND(",",A1,FIND(",",A1)+1)-(FIND(",",A1)+1)) please help...

www.mrexcel.com

 

[dummies]

Does it have to be with vba?

Can you show us how the result(s) should be shown?

Better still, can you show us a variety of input data (it sounds like sometimes it might not all be numeric), preferably with XL2BB so we can copy/paste to test with and include the expected results?

thank you for the response.
yes it is. Actually i have a table which has product name and product no. so i want to check if product no contain product no.

<table style="width:100%">
  <tr>
    <th>prodeuctName</th>
    <th>productNo</th>
    
  </tr>
  <tr>
    <td>s12-12-123</td>
    <td>12-12-123</td>
    
  </tr>
  <tr>
    <td>s12-12-124</td>
    <td>12-12-124</td>
  
  </tr>
</table>

 

[Peter_SSs]

Unfortunately, as you can see, you cannot show sample data like that.

Also, this does not make sense to me:

i want to check if product no contain product no.

 

[Dossfm0q]

المصنف1
	A	B
1	12-12-123-AA
2	12	TRUE
3	12	TRUE
4	123	TRUE
5	AA	FALSE
ورقة1

Cell Formulas
Range	Formula
A2:A5	A2	=IFERROR(TRIM(MID($A$1,FIND("|",SUBSTITUTE("-"&$A$1&"-","-","|",ROW()-ROW($A$2)+1)),FIND("|",SUBSTITUTE(" "&$A$1&"-","-","|",ROW()-ROW($A$2)+1))-FIND("|",SUBSTITUTE("-"&$A$1&"-","-","|",ROW()-ROW($A$2)+1))-1)),"")
B2:B5	B2	=IFERROR(ISNUMBER(NUMBERVALUE(TRIM(MID($A$1,FIND("|",SUBSTITUTE("-"&$A$1&"-","-","|",ROW()-ROW($A$2)+1)),FIND("|",SUBSTITUTE(" "&$A$1&"-","-","|",ROW()-ROW($A$2)+1))-FIND("|",SUBSTITUTE("-"&$A$1&"-","-","|",ROW()-ROW($A$2)+1))-1)))),"")

 

[dummies]

Unfortunately, as you can see, you cannot show sample data like that.

Also, this does not make sense to me:

sorry i mean to say, check if column (product no) contains product name.
productNo=12-12-123
productName=s12-12-123

 

[dummies]

المصنف1
	A	B
1	12-12-123-AA
2	12	TRUE
3	12	TRUE
4	123	TRUE
5	AA	FALSE
ورقة1

Cell Formulas
Range	Formula
A2:A5	A2	=IFERROR(TRIM(MID($A$1,FIND("|",SUBSTITUTE("-"&$A$1&"-","-","|",ROW()-ROW($A$2)+1)),FIND("|",SUBSTITUTE(" "&$A$1&"-","-","|",ROW()-ROW($A$2)+1))-FIND("|",SUBSTITUTE("-"&$A$1&"-","-","|",ROW()-ROW($A$2)+1))-1)),"")
B2:B5	B2	=IFERROR(ISNUMBER(NUMBERVALUE(TRIM(MID($A$1,FIND("|",SUBSTITUTE("-"&$A$1&"-","-","|",ROW()-ROW($A$2)+1)),FIND("|",SUBSTITUTE(" "&$A$1&"-","-","|",ROW()-ROW($A$2)+1))-FIND("|",SUBSTITUTE("-"&$A$1&"-","-","|",ROW()-ROW($A$2)+1))-1)))),"")

View attachment 27558

This is similar to what I really what to do.if possible could you help me to do it in vba. Thank you very much.

 

[Peter_SSs]

check if column (product no) contains product name.

I'm guessing you actually mean that the other way around. That is "check if product name contains product no."
If so, you could try this with a copy of your data.

Sub NumberInName()
  Dim a As Variant, b As Variant
  Dim i As Long
  
  a = Range("A2", Range("B" & Rows.Count).End(xlUp)).Value
  ReDim b(1 To UBound(a), 1 To 1)
  For i = 1 To UBound(a)
    b(i, 1) = IIf(InStr(1, a(i, 1), a(i, 2), 1) > 0, "Yes", "No")
  Next i
  Range("C2").Resize(UBound(b)).Value = b
End Sub

Here is my sample data and results

dummies.xlsm
	A	B	C
1	product name	product no.	Product no. in product name?
2	s12-12-123	12-12-123	Yes
3	s12-12-124	15-19-195	No
Sheet1

 

[dummies]

I'm guessing you actually mean that the other way around. That is "check if product name contains product no."
If so, you could try this with a copy of your data.

Sub NumberInName()
  Dim a As Variant, b As Variant
  Dim i As Long

  a = Range("A2", Range("B" & Rows.Count).End(xlUp)).Value
  ReDim b(1 To UBound(a), 1 To 1)
  For i = 1 To UBound(a)
    b(i, 1) = IIf(InStr(1, a(i, 1), a(i, 2), 1) > 0, "Yes", "No")
  Next i
  Range("C2").Resize(UBound(b)).Value = b
End Sub

Here is my sample data and results

dummies.xlsm
	A	B	C
1	product name	product no.	Product no. in product name?
2	s12-12-123	12-12-123	Yes
3	s12-12-124	15-19-195	No
Sheet1

thank you so much.
what if , if i have checkbox next to productName and if i check the checkbox(C5) then value in A5 is displayed in textbox next to checkbox?