count number

[sohaila]

Hello
how can i count six number of digit in cell
like
dhfjd 787845 fdjhjdhf 996 478596 kdfkdhf 4 eretetr 475812 fdf
the result is 3

 

[mohadin]

Hi
Try

Function cont(trgt As Range)
    Dim m
    With CreateObject("VBScript.RegExp")
        .Global = True
        .Pattern = "(\d+){6}"
        Set m = .Execute(trgt)
        cont = m.Count
    End With
End Function

Use
=cont(A1)

 

[sohaila]

Is this possible in excel formulas ?

 

[sohaila]

and one only count 6 digit not 6 to above and below

 

[navic]

If you have the option to use an helper column on the Sheet,
Try to see the solutions on this link (maybe these solutions can help you solve the task)

Extract multiple 5-digit numbers from alphanumeric text

Hello, I need to extract multiple 5-digit numbers from a cell that contains both letters and numbers. I found a thread that solves for how to extract a single number but this doesn't work for me because my data might contain multiple 5-digit numbers. Here is an example of how my data looks...

www.mrexcel.com