Separate Text and Numbers in Excel

[@Luciano_mp]

Good example. Thanks Doug.

[@DougHExcel]

Thanks for watching Luciano!

[@rutendorusemo4792]

you just saved me. i couldnt understand all those long fomulars and VBA thing. You are the best

[@DougHExcel]

Thanks, glad it helped!

[@rouserboy5177]

Thankyou sir...you just save my time.

[@DougHExcel]

Glad to hear that!

[@Technooff445]

It's too much helpful ! 👍

[@DougHExcel]

Thanks 🙏!

[@mattmatt245]

I have a question. Is there an easy way to count blanks per row in power query ?

[@JCEurovisionFan1996]

Doug, there's no SORT, FILTER, UNIQUE, and SORTBY function in Excel 2019. What are the alternatives for these?

[@DougHExcel]

Other tools like advanced filter, table filter, or pivot tables.