Forum Discussion

WJ876400's avatar
WJ876400
Icon for Helper IV rankHelper 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
Icon for Helper IV rankHelper IV
6 years ago

Hi Anonymous 

 

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

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi WJ876400 ,

While writting this logic, I assumed that the Numbers would appear only at the end of the string.

Is that correct?

 

Thanks.

  • WJ876400's avatar
    WJ876400
    Icon for Helper IV rankHelper IV
    6 years ago

    Hi Anonymous 

     

    Sorry there is a number at the front but i have solved the issue now thank you