Top of the evening to you all!
I'm actually a little surprised that I have not seen this question anywhere on here. I am looking to find the position of a character in a cell. In my case, I'm looking for the first instance of a number of 7 or over, but to ignore all zeros.
For example: 0035375799
In this case, I would like the cell to return a "4", because the first instance of a 7 or over (disregarding zeros) is at the fourth number.
Does anyone have any suggestions for what formulae I should be using?
Thanks a bunch!
Bookmarks