Forum Discussion

Avicric's avatar
Avicric
Frequent Visitor
2 years ago
Solved

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

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

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

     

    Replace [Column1] with your column name.

1 Reply

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

     

    Replace [Column1] with your column name.