{"id":9160,"date":"2025-12-17T07:02:23","date_gmt":"2025-12-17T07:02:23","guid":{"rendered":"https:\/\/mailitics.com\/index.php\/2025\/12\/17\/separate-numbers-and-text-in-one-column-using-power-query\/"},"modified":"2025-12-17T07:02:23","modified_gmt":"2025-12-17T07:02:23","slug":"separate-numbers-and-text-in-one-column-using-power-query","status":"publish","type":"post","link":"https:\/\/mailitics.com\/index.php\/2025\/12\/17\/separate-numbers-and-text-in-one-column-using-power-query\/","title":{"rendered":"Separate Numbers and Text in One Column Using Power Query"},"content":{"rendered":"<p>    Separate Numbers and Text in One Column Using Power Query<br \/>\n \t<BR><br \/>\n<BR><\/BR><br \/>\n    <!-- no image --><br \/>\n \t<BR><br \/>\n<BR><\/BR><\/p>\n<div>\n<p>An Excel sheet with a column containing numbers and text? What a mess!<\/p>\n<p>The post <a href=\"https:\/\/towardsdatascience.com\/separate-numbers-and-text-in-one-column-using-power-query\/\">Separate Numbers and Text in One Column Using Power Query<\/a> appeared first on <a href=\"https:\/\/towardsdatascience.com\/\">Towards Data Science<\/a>.<\/p>\n<\/div>\n<p> \t<BR><br \/>\n <BR><\/BR><br \/>\n    Salvatore Cagliari<br \/>\n \t<BR><br \/>\n<BR><\/BR><br \/>\n<a href=\"https:\/\/towardsdatascience.com\/separate-numbers-and-text-in-one-column-using-power-query\/\">Go to original source<\/a><br \/>\n \t<BR><br \/>\n <BR><\/BR><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Separate Numbers and Text in One Column Using Power Query An Excel sheet with a column containing numbers and text? What a mess! The post Separate Numbers and Text in One Column Using Power Query appeared first on Towards Data Science. Salvatore Cagliari Go to original source<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[62,1744,211,83,245,1360,244],"tags":[2717,4442,834],"class_list":["post-9160","post","type-post","status-publish","format-standard","hentry","category-aimldsaimlds","category-data-engineer","category-data-analysis","category-data-science","category-excel","category-power-bi","category-power-query","tag-column","tag-numbers","tag-text"],"_links":{"self":[{"href":"https:\/\/mailitics.com\/index.php\/wp-json\/wp\/v2\/posts\/9160"}],"collection":[{"href":"https:\/\/mailitics.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mailitics.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mailitics.com\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/mailitics.com\/index.php\/wp-json\/wp\/v2\/comments?post=9160"}],"version-history":[{"count":0,"href":"https:\/\/mailitics.com\/index.php\/wp-json\/wp\/v2\/posts\/9160\/revisions"}],"wp:attachment":[{"href":"https:\/\/mailitics.com\/index.php\/wp-json\/wp\/v2\/media?parent=9160"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mailitics.com\/index.php\/wp-json\/wp\/v2\/categories?post=9160"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mailitics.com\/index.php\/wp-json\/wp\/v2\/tags?post=9160"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}