Hello,
Does Excel (2013) have a command which will search for the position of the first number or digit in a string of text?
The command =SEARCH() will return the position of the first specified character or sequence of characters in a given cell. However, suppose you want to determine the position of the first of any of the ten primary digits (ie 0, 1, 2, 3...9) in a cell. Is there a way to do that?
For example, such a command would return the following results:
5 — for a cell containing "mT z7DL2x Y"
8 — for a cell containing "g DqQj 3vd2AEp"
2 — for a cell containing "y4tKgu"
6 — for a cell containing "tq k8w3a4"
and so on.
Thanks