Using power query to know the position of the first occuring number

[Avicric]

Hi All,

I have a column which has data in alphanumeric form

I need a formula which can help me know the position of the first occuring number.

Example

Avi2323 = 4

 Avi2456 = 5

234-678  = 1

My constraints

There can be space at the start

Thank you

[jgeddes · Accepted solution]

You can add a new column with the following code...

Replace [Column1] with your column name.