Forum Discussion
Avicric
2 years agoFrequent Visitor
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
- jgeddes
Super User
You can add a new column with the following code...
Replace [Column1] with your column name.