Forum Discussion
Hogstad_Raadgivning
Aug 12, 2021Steel Contributor
Find 7# digits in a string
Hi, I have text string where I would like et select numbers only from. And i manage to do that. But it find all the numbers, is it possible to only select the numbers when it is 7 digits concaten...
HansVogelaar
Feb 01, 2022MVP
Let's say you enter the number 17 in cell A1 and the number 5 in cell B1.
In cell C1, enter the formula =QUOTIENT(A1,B1)
If you use comma as decimal separator, enter =QUOTIENT(A1;B1) instead.
The formula will return 3, because 5 goes 3 times into 17, with a remainder of 2: 17 = 3*5+2