counting the number of the integers within text?

[dwx]

Is there a way to count the number of integers in e.g.

8400,3311 ,5123, a23 = 3

3323,9993,4abc, 1990 = 3

[email protected] = 3

A245,5555,113$.AB = 1


Only counting the sets of 4 digits, excludes all alphabet.

[FDibbins]

Hi and welcome to the forum

Im sure that someone will give you a better solution, but until then, see if this is something you can use...

1. use Text-to-Columns to split the string, using both , (comma) and . as the delimiters. This will give you most of the numbers, you may need to do T2C again with @
2. use =count(range) to give you the qty of mumbers

[FDibbins]

Hi and welcome to the forum

Im sure that someone will give you a better solution, but until then, see if this is something you can use...

1. use Text-to-Columns to split the string, using both , (comma) and . as the delimiters. This will give you most of the numbers, you may need to do T2C again with @
2. use =count(range) to give you the qty of mumbers