{"id":64846,"date":"2026-06-16T11:42:09","date_gmt":"2026-06-16T10:42:09","guid":{"rendered":"https:\/\/hlrnet.com\/technoblog\/inicio\/?p=64846"},"modified":"2026-06-16T11:42:09","modified_gmt":"2026-06-16T10:42:09","slug":"i-tried-these-6-new-excel-functions-and-they-saved-me-a-ton-of-time","status":"publish","type":"post","link":"https:\/\/hlrnet.com\/technoblog\/inicio\/i-tried-these-6-new-excel-functions-and-they-saved-me-a-ton-of-time\/","title":{"rendered":"&#8220;I tried these 6 new Excel functions and they saved me a ton of time&#8221;"},"content":{"rendered":"<p>I tried these 6 new Excel functions and they saved me a ton of time<br \/>\n<a href=\"https:\/\/www.makeuseof.com\/new-excel-functions-worth-learning-this-year\/\" rel=\"nofollow\">https:\/\/www.makeuseof.com\/new-excel-functions-worth-learning-this-year\/<\/a><\/p>\n<ul>\n<li>Regular expression (regex) functions<br \/>\nFind, extract, and clean data without endless text formulas<\/p>\n<ul>\n<li>regexreplace<br \/>\nREGEXREPLACE Function | Microsoft Support<br \/>\n<a href=\"https:\/\/support.microsoft.com\/en-us\/excel\/regexreplace-function\" rel=\"nofollow\">https:\/\/support.microsoft.com\/en-us\/excel\/regexreplace-function<\/a><\/li>\n<li>regextest<br \/>\nREGEXTEST Function | Microsoft Support<br \/>\n<a href=\"https:\/\/support.microsoft.com\/en-us\/excel\/regextest-function\" rel=\"nofollow\">https:\/\/support.microsoft.com\/en-us\/excel\/regextest-function<\/a><\/li>\n<li>regexextract<br \/>\nREGEXEXTRACT Function | Microsoft Support<br \/>\n<a href=\"https:\/\/support.microsoft.com\/en-us\/excel\/regexextract-function\" rel=\"nofollow\">https:\/\/support.microsoft.com\/en-us\/excel\/regexextract-function<\/a><\/li>\n<\/ul>\n<\/li>\n<li>IMPORTTEXT and IMPORTCSV<br \/>\nBring in CSV and text files without touching Power Query<\/p>\n<ul>\n<li>importcsv<br \/>\nIMPORTCSV function | Microsoft Support<br \/>\n<a href=\"https:\/\/support.microsoft.com\/en-us\/excel\/importcsv-function\" rel=\"nofollow\">https:\/\/support.microsoft.com\/en-us\/excel\/importcsv-function<\/a><\/li>\n<li>importtext<br \/>\nIMPORTTEXT function | Microsoft Support<br \/>\n<a href=\"https:\/\/support.microsoft.com\/en-us\/excel\/importtext-function\" rel=\"nofollow\">https:\/\/support.microsoft.com\/en-us\/excel\/importtext-function<\/a><\/li>\n<\/ul>\n<\/li>\n<li>LAMBDA Function<br \/>\nBuild formulas once and reuse them everywhere<\/p>\n<ul>\n<li>lambda<br \/>\nLAMBDA function | Microsoft Support<br \/>\n<a href=\"https:\/\/support.microsoft.com\/en-us\/excel\/lambda-function\" rel=\"nofollow\">https:\/\/support.microsoft.com\/en-us\/excel\/lambda-function<\/a><\/li>\n<\/ul>\n<\/li>\n<li>IMAGE Function<br \/>\nPull logos, flags, and photos directly into cells<\/p>\n<ul>\n<li>image<br \/>\nIMAGE function | Microsoft Support<br \/>\n<a href=\"https:\/\/support.microsoft.com\/en-us\/excel\/image-function\" rel=\"nofollow\">https:\/\/support.microsoft.com\/en-us\/excel\/image-function<\/a><\/li>\n<\/ul>\n<\/li>\n<li>TRIMRANGE Function<br \/>\nTrim away empty rows and columns before they cause problems<\/p>\n<ul>\n<li>trimrange<br \/>\nTRIMRANGE function | Microsoft Support<br \/>\n<a href=\"https:\/\/support.microsoft.com\/en-us\/Excel\/trimrange-function\" rel=\"nofollow\">https:\/\/support.microsoft.com\/en-us\/Excel\/trimrange-function<\/a><\/li>\n<\/ul>\n<\/li>\n<li>DETECTLANGUAGE and TRANSLATE functions<br \/>\nBreak language barriers<\/p>\n<ul>\n<li>detectlanguage<br \/>\nDETECTLANGUAGE function | Microsoft Support<br \/>\n<a href=\"https:\/\/support.microsoft.com\/en-us\/Excel\/detectlanguage-function\" rel=\"nofollow\">https:\/\/support.microsoft.com\/en-us\/Excel\/detectlanguage-function<\/a><\/li>\n<li>translate<br \/>\nTRANSLATE function | Microsoft Support<br \/>\n<a href=\"https:\/\/support.microsoft.com\/en-us\/excel\/translate-function\" rel=\"nofollow\">https:\/\/support.microsoft.com\/en-us\/excel\/translate-function<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>I tried these 6 new Excel functions and they saved me a ton of time https:\/\/www.makeuseof.com\/new-excel-functions-worth-learning-this-year\/ Regular expression (regex) functions Find, extract, and clean data without endless text formulas regexreplace REGEXREPLACE Function | Microsoft Support https:\/\/support.microsoft.com\/en-us\/excel\/regexreplace-function regextest REGEXTEST Function | Microsoft Support https:\/\/support.microsoft.com\/en-us\/excel\/regextest-function regexextract REGEXEXTRACT Function | Microsoft Support https:\/\/support.microsoft.com\/en-us\/excel\/regexextract-function<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"iawp_total_views":2,"footnotes":""},"categories":[54,375,10],"tags":[],"class_list":["post-64846","post","type-post","status-publish","format-standard","hentry","category-excel","category-excel-office-2010","category-office"],"publishpress_future_action":{"enabled":false,"date":"2026-06-26 13:09:20","action":"delete","newStatus":"draft","terms":[],"taxonomy":"category","extraData":[]},"publishpress_future_workflow_manual_trigger":{"enabledWorkflows":[]},"_links":{"self":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/posts\/64846","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/comments?post=64846"}],"version-history":[{"count":0,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/posts\/64846\/revisions"}],"wp:attachment":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/media?parent=64846"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/categories?post=64846"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/tags?post=64846"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}