How To Separate Numbers From Text In Excel || When The Number is at the start of text

[@sandeepkumar-cx4or]

thanks a lot of you sir ji

[@dptutorials]

Thanks a lot for the feedback.

[@paulgradwell2510]

This is excellent and very well explained, thank you.

[@dptutorials]

Glad it was helpful!

[@IrfanKhan-wv8rh]

Excellent sir, thank you so much

[@dptutorials]

Most welcome

[@ayushsrivastava9775]

thank u sir

[@dptutorials]

So nice of you

[@mihajlovicrus]

It is not working when I have - before number, e.g. -482, please kindly advise. thx

[@bothexrotasi9207]

Can u make for Mobile version

[@Ridetoright111]

How this was numerous function for one result..

[@chriskumar2178]

Not working

[@dahirualiyu6494]

I believe there is more shorter argument to get exact result, the formula is tooo long.