Forum Discussion

WJ876400's avatar
WJ876400
Helper IV
6 years ago
Solved

Slpit numbers from text

Hi   How do I split the number from the end of this text and have the value as a number.      Thank you for any help
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    6 years ago

    WJ876400 

     

    Using Power Query, you can try this

     

    Select Column>>>Go to TRANSFORM Tab>>Split Column>>BY Non digit to digit


WJ876400's avatar
WJ876400
Helper IV
6 years ago

Hi Anonymous 

 

Thankyou for the response. I tried that but got an error which is below

 

Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
6 years ago

WJ876400 

 

Using Power Query, you can try this

 

Select Column>>>Go to TRANSFORM Tab>>Split Column>>BY Non digit to digit