{"id":7361,"date":"2022-10-03T15:08:00","date_gmt":"2022-10-03T09:38:00","guid":{"rendered":"https:\/\/exceltrick.com\/?p=7361"},"modified":"2023-03-18T23:45:37","modified_gmt":"2023-03-18T18:15:37","slug":"excel-clean-function","status":"publish","type":"post","link":"https:\/\/exceltrick.com\/functions\/excel-clean-function\/","title":{"rendered":"Excel CLEAN Function \u2013 How To Use"},"content":{"rendered":"<p>The CLEAN function comes under the category of text\/string functions in Excel. It is used to remove first 32 non-printable characters from the text.<\/p>\n<p>Based on the 7-bit ASCII character set, codes starting from 0 to 31 are considered as Non-Printing Control Characters such as horizontal tab, vertical tab, carriage return etc.<\/p>\n<p>The CLEAN function is usually used when dealing with a large amount of exported data that contains non-printable characters like line breaks due to encoding differences between different systems and devices.<\/p>\n<img decoding=\"async\" class=\"aligncenter size-full wp-image-7382\" src=\"https:\/\/exceltrick.com\/wp-content\/uploads\/2022\/10\/Excel-CLEAN-Function.png\" alt=\"Excel CLEAN Function\" width=\"753\" height=\"396\" title=\"\">\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_53 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title \" >Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\" role=\"button\"><label for=\"item-69f5a8a2af24b\" ><span class=\"\"><span style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input aria-label=\"Toggle\" aria-label=\"item-69f5a8a2af24b\"  type=\"checkbox\" id=\"item-69f5a8a2af24b\"><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/exceltrick.com\/functions\/excel-clean-function\/#Syntax\" title=\"Syntax\">Syntax<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/exceltrick.com\/functions\/excel-clean-function\/#Important_Characteristics_of_the_CLEAN_function\" title=\"Important Characteristics of the CLEAN function\">Important Characteristics of the CLEAN function<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/exceltrick.com\/functions\/excel-clean-function\/#Examples\" title=\"Examples\">Examples<\/a><ul class='ez-toc-list-level-3'><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/exceltrick.com\/functions\/excel-clean-function\/#Example_1_%E2%80%93_Cleaning_Numeric_Data_in_Excel\" title=\"Example 1 &#8211; Cleaning Numeric Data in Excel\">Example 1 &#8211; Cleaning Numeric Data in Excel<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/exceltrick.com\/functions\/excel-clean-function\/#Example_2_%E2%80%93_Removing_Line_Breaks_in_Excel\" title=\"Example 2 &#8211; Removing Line Breaks in Excel\">Example 2 &#8211; Removing Line Breaks in Excel<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/exceltrick.com\/functions\/excel-clean-function\/#Example_3_%E2%80%93_Finding_Non-Printable_Characters_in_Data\" title=\"Example 3 &#8211; Finding Non-Printable Characters in Data\">Example 3 &#8211; Finding Non-Printable Characters in Data<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/exceltrick.com\/functions\/excel-clean-function\/#Example_4_%E2%80%93_How_to_Clean_Extra_Spaces\" title=\"Example 4 &#8211; How to Clean Extra Spaces\">Example 4 &#8211; How to Clean Extra Spaces<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/exceltrick.com\/functions\/excel-clean-function\/#Example_5_%E2%80%93_Removing_Unicode_Non-printing_Characters\" title=\"Example 5 &#8211; Removing Unicode Non-printing Characters\">Example 5 &#8211; Removing Unicode Non-printing Characters<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/exceltrick.com\/functions\/excel-clean-function\/#CLEAN_vs_TRIM_Function\" title=\"CLEAN vs. TRIM Function\">CLEAN vs. TRIM Function<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Syntax\"><\/span>Syntax<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>The syntax of the CLEAN function is as follows:<\/p>\n<div class=\"excelFormula\"><code><span class=\"operator\">=<\/span><span class=\"function\">CLEAN<\/span>(text)<\/code><\/div>\n<p style=\"margin: 0px;\"><strong>Arguments:<\/strong><\/p>\n<p style=\"padding-left: 30px;\">&#39;<em>text<\/em>&#39; &#8211; The text argument can be supplied in double quotes or as a cell reference.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Important_Characteristics_of_the_CLEAN_function\"><\/span>Important Characteristics of the CLEAN function<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Some of the notable features of the CLEAN function are as follows.<\/p>\n<ul>\n<li>The CLEAN function only removes the first 32 characters from the 7 bit ASCII character set.<\/li>\n<li>Non-printable characters from the Unicode character set (values 127, 129, 141, 143, 144, 157 and 160) cannot be removed using this function.<\/li>\n<li>If the <em>text <\/em>argument is in numeric format, the return value will be in text format.<\/li>\n<li>The CLEAN Function only works in Excel 2003 and versions after that.<\/li>\n<\/ul>\n<h2><span class=\"ez-toc-section\" id=\"Examples\"><\/span>Examples<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>The CLEAN function when used in a straightforward manner simply removes all the ASCII non-printable characters from the given data. In this example, cell B2 contains text copied from a webpage and therefore includes some non-printable data.<\/p>\n<p>Using the function as follows:<\/p>\n<div class=\"excelFormula\"><code><span class=\"operator\">=<\/span><span class=\"function\">CLEAN<\/span>(B2)<\/code><\/div>\n<img decoding=\"async\" class=\"aligncenter size-full wp-image-7366\" src=\"https:\/\/exceltrick.com\/wp-content\/uploads\/2022\/10\/clean-function-in-excel_01.png\" alt=\"Examples of CLEAN Function in Excel \" width=\"670\" height=\"142\" title=\"\">\n<p>We now have the clean text in cell C2.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Example_1_%E2%80%93_Cleaning_Numeric_Data_in_Excel\"><\/span>Example 1 &#8211; Cleaning Numeric Data in Excel<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Suppose we enquired about a few mobile phones and received the prices of all of them in a spreadsheet. Upon downloading, we realized that there are some non-printable characters in the data which creates an issue while calculating the total sum.<\/p>\n<img decoding=\"async\" class=\"aligncenter size-full wp-image-7367\" src=\"https:\/\/exceltrick.com\/wp-content\/uploads\/2022\/10\/clean-function-in-excel_02.png\" alt=\"Cleaning Numeric Data in Excel\" width=\"405\" height=\"288\" title=\"\">\n<p>One option is to manually clean the data in column C (prices), which is an ineffective approach. Instead, a quicker approach is using the CLEAN function, where we can easily remove all the non-printable characters using the below formula.<\/p>\n<div class=\"excelFormula\"><code><span class=\"operator\">=<\/span><span class=\"function\">CLEAN<\/span>(C3)<\/code><\/div>\n<img decoding=\"async\" class=\"aligncenter size-full wp-image-7368\" src=\"https:\/\/exceltrick.com\/wp-content\/uploads\/2022\/10\/clean-function-in-excel_03.png\" alt=\"Cleaning Numeric Data in Excel\" width=\"541\" height=\"331\" title=\"\">\n<p>As the CLEAN function is a text function, the problem is that all the cleaned values are now in text format. Hence, the sum of all the prices in cell D10 is 0. We can easily rectify it using the VALUE function which converts the numbers in text format to numerical format. The formula used will be as follows.<\/p>\n<div class=\"excelFormula\"><code><span class=\"operator\">=<\/span><span class=\"function\">VALUE<\/span>(D3)<\/code><\/div>\n<img decoding=\"async\" class=\"aligncenter size-full wp-image-7369\" src=\"https:\/\/exceltrick.com\/wp-content\/uploads\/2022\/10\/clean-function-in-excel_04.png\" alt=\"Cleaning Numeric Data in Excel\" width=\"632\" height=\"330\" title=\"\">\n<p>Now, we have all the mobile prices in a numeric format without any non-printable characters. To minimize the number of steps and make it cleaner, we can use all both the functions together as follows.<\/p>\n<div class=\"excelFormula\"><code><span class=\"operator\">=<\/span><span class=\"function\">VALUE<\/span>(<span class=\"function\">CLEAN<\/span>(C3))<\/code><\/div>\n<img decoding=\"async\" class=\"aligncenter size-full wp-image-7370\" src=\"https:\/\/exceltrick.com\/wp-content\/uploads\/2022\/10\/clean-function-in-excel_05.png\" alt=\"Cleaning Numeric Data in Excel\" width=\"487\" height=\"331\" title=\"\">\n<h3><span class=\"ez-toc-section\" id=\"Example_2_%E2%80%93_Removing_Line_Breaks_in_Excel\"><\/span>Example 2 &#8211; Removing Line Breaks in Excel<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>In this example, we have a dataset with some names and addresses. The addresses are written with line breaks for better understanding. However, we wish to have the addresses without line breaks before storing them to our database.<\/p>\n<img decoding=\"async\" class=\"aligncenter size-full wp-image-7371\" src=\"https:\/\/exceltrick.com\/wp-content\/uploads\/2022\/10\/clean-function-in-excel_06.png\" alt=\"Removing Line Breaks in Excel\" width=\"474\" height=\"552\" title=\"\">\n<p>Using the CLEAN function directly on column C will give us the desired result. The formula used will be as follows.<\/p>\n<div class=\"excelFormula\"><code><span class=\"operator\">=<\/span><span class=\"function\">CLEAN<\/span>(C2)<\/code><\/div>\n<img decoding=\"async\" class=\"aligncenter size-full wp-image-7372\" src=\"https:\/\/exceltrick.com\/wp-content\/uploads\/2022\/10\/clean-function-in-excel_07.png\" alt=\"Removing Line Breaks in Excel\" width=\"859\" height=\"595\" title=\"\">\n<p><strong>Note:<\/strong><\/p>\n<p>There is another approach to accomplish the above. We know that a line break corresponds to ASCII value 10. So we can use the <a href=\"https:\/\/exceltrick.com\/functions\/excel-substitute-function\/\">SUBSTITUTE function<\/a> to replace CHAR(10) with an empty string, thereby removing the line breaks from the text.<\/p>\n<p>The formula would be:<\/p>\n<div class=\"excelFormula\"><code><span class=\"operator\">=<\/span><span class=\"function\">SUBSTITUTE<\/span>(C2,<span class=\"function\">CHAR<\/span>(10),\"\")<\/code><\/div>\n<h3><span class=\"ez-toc-section\" id=\"Example_3_%E2%80%93_Finding_Non-Printable_Characters_in_Data\"><\/span>Example 3 &#8211; Finding Non-Printable Characters in Data<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Until now we have determined how to clean text, string, and numeric data using the CLEAN function. However, CLEAN function also allows us check if there are any non-printable characters in the text and if there are any such characters, we can ever get their count.<\/p>\n<p>Let&#39;s see how.<\/p>\n<p>Suppose you are in the marketing department and exported some data from an online tool for processing. We are here to check whether the exported data contains any non-printable characters or if we will have to clean it.<\/p>\n<p>In this dataset, we have a few Facebook posts and their engagement numbers (number of likes).<\/p>\n<img decoding=\"async\" class=\"aligncenter size-full wp-image-7373\" src=\"https:\/\/exceltrick.com\/wp-content\/uploads\/2022\/10\/clean-function-in-excel_08.png\" alt=\"Finding Non-Printable Characters in Data\" width=\"676\" height=\"410\" title=\"\">\n<p>To determine if the downloaded data contains any non-printable characters, we will use the <a href=\"https:\/\/exceltrick.com\/functions\/excel-if-statement\/\">IF function<\/a> combined with LEN and CLEAN functions. The logic we will use is as follows.<\/p>\n<p>We will compare the length of the original string and the length of the cleaned string. If there is any difference between the lengths that indicates there are non-printing characters in the string.<\/p>\n<p>We can even go one step further and print the difference between the lengths of the original string and the cleaned string, this difference will be the number of non-printing characters in the original string. If the string lengths are same, we will print a message &quot;Clean Text&quot;.<\/p>\n<p>The difference in the length of the clean text and the original text is the number of non-printable characters. It can be easily calculated as follows.<\/p>\n<div class=\"excelFormula\"><code><span class=\"operator\">=<\/span><span class=\"function\">LEN<\/span>(B3)<span class=\"operator\">-<\/span><span class=\"function\">LEN<\/span>(<span class=\"function\">CLEAN<\/span>(B3))<\/code><\/div>\n<p>Combining the above IF logic in the Excel function, the final formula will look like this.<\/p>\n<div class=\"excelFormula\"><code><span class=\"operator\">=<\/span><span class=\"function\">IF<\/span>((<span class=\"function\">LEN<\/span>(B3)<span class=\"operator\">-<\/span><span class=\"function\">LEN<\/span>(<span class=\"function\">CLEAN<\/span>(B3))) <span class=\"operator\">&gt;<\/span> 0, (<span class=\"function\">LEN<\/span>(B3)<span class=\"operator\">-<\/span><span class=\"function\">LEN<\/span>(<span class=\"function\">CLEAN<\/span>(B3)))<span class=\"operator\">&amp;<\/span>\" <span class=\"string\">Non-printable Characters Found.<\/span>\", \"<span class=\"string\">Clean Text<\/span>\")<\/code><\/div>\n<img decoding=\"async\" class=\"aligncenter size-full wp-image-7374\" src=\"https:\/\/exceltrick.com\/wp-content\/uploads\/2022\/10\/clean-function-in-excel_09.png\" alt=\"Finding Non-Printable Characters in Data\" width=\"893\" height=\"444\" title=\"\">\n<p>Now, we can analyze how many non-printable characters are there in the data and use them accordingly.<\/p>\n<p>But what if the data contain extra spaces along with non-printable characters?<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Example_4_%E2%80%93_How_to_Clean_Extra_Spaces\"><\/span>Example 4 &#8211; How to Clean Extra Spaces<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>In the dataset, we downloaded a few quotes from a webpage. The data contains extra spaces and non-printable characters and, therefore, cannot be used as such.<\/p>\n<img decoding=\"async\" class=\"aligncenter size-full wp-image-7375\" src=\"https:\/\/exceltrick.com\/wp-content\/uploads\/2022\/10\/clean-function-in-excel_10.png\" alt=\"How to Clean Extra Spaces\" width=\"742\" height=\"125\" title=\"\">\n<p>As we can see, there is a line break, unnecessary trailing spaces, and non-printable characters. When tried using the CLEAN function, it only cleared up the line break and non-printable characters. The formula used is as follows.<\/p>\n<div class=\"excelFormula\"><code><span class=\"operator\">=<\/span><span class=\"function\">CLEAN<\/span>(C2)<\/code><\/div>\n<img decoding=\"async\" class=\"aligncenter size-full wp-image-7376\" src=\"https:\/\/exceltrick.com\/wp-content\/uploads\/2022\/10\/clean-function-in-excel_11.png\" alt=\"How to Clean Extra Spaces\" width=\"707\" height=\"185\" title=\"\">\n<p>The CLEAN function clears up all the characters ranging from 0-31 ASCII code; and space corresponds to ASCII code 32. Here we can make use of the <a href=\"https:\/\/exceltrick.com\/functions\/excel-trim-function\/\">TRIM function<\/a>. TRIM Function is used to clean up extra spaces in the text. So, let&#39;s try using the TRIM function to eliminate spaces.<\/p>\n<div class=\"excelFormula\"><code><span class=\"operator\">=<\/span><span class=\"function\">TRIM<\/span>(C2)<\/code><\/div>\n<img decoding=\"async\" class=\"aligncenter size-full wp-image-7377\" src=\"https:\/\/exceltrick.com\/wp-content\/uploads\/2022\/10\/clean-function-in-excel_12.png\" alt=\"How to Clean Extra Spaces\" width=\"717\" height=\"211\" title=\"\">\n<p>As we can see, the TRIM function cleared the trailing spaces and extra spaces, leaving no spaces at the beginning or end of the text and only one space between words. The line break and non-printable characters still exist.<\/p>\n<p>We can clearly use both functions together to clean up our data. Using both TRIM and CLEAN functions together as follows.<\/p>\n<div class=\"excelFormula\"><code><span class=\"operator\">=<\/span><span class=\"function\">TRIM<\/span>(<span class=\"function\">CLEAN<\/span>(C2))<\/code><\/div>\n<img decoding=\"async\" class=\"aligncenter size-full wp-image-7378\" src=\"https:\/\/exceltrick.com\/wp-content\/uploads\/2022\/10\/clean-function-in-excel_13.png\" alt=\"How to Clean Extra Spaces\" width=\"745\" height=\"186\" title=\"\">\n<p>While the CLEAN function is great for getting rid of non-printable ASCII characters. But you might want to get rid of a few non-printable characters outside the ASCII range, such as non-breaking space characters (160), which are commonly used in HTML.<\/p>\n<p>Let&#39;s see how we can get rid of Unicode Non-printing characters.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Example_5_%E2%80%93_Removing_Unicode_Non-printing_Characters\"><\/span>Example 5 &#8211; Removing Unicode Non-printing Characters<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>In this example, we have two similar-looking sentences in cells B2 and B3. Both contain extra space at the beginning and a non-printable character.<\/p>\n<img decoding=\"async\" class=\"aligncenter size-full wp-image-7379\" src=\"https:\/\/exceltrick.com\/wp-content\/uploads\/2022\/10\/clean-function-in-excel_14.png\" alt=\"Removing Unicode Non-printing Characters\" width=\"498\" height=\"124\" title=\"\">\n<p>Let&#39;s use the solution mentioned above of combining the TRIM and CLEAN functions to clear up the data. The formula will go as follows.<\/p>\n<div class=\"excelFormula\"><code><span class=\"operator\">=<\/span><span class=\"function\">TRIM<\/span>(<span class=\"function\">CLEAN<\/span>(B2))<\/code><\/div>\n<img decoding=\"async\" class=\"aligncenter size-full wp-image-7380\" src=\"https:\/\/exceltrick.com\/wp-content\/uploads\/2022\/10\/clean-function-in-excel_15.png\" alt=\"Removing Unicode Non-printing Characters\" width=\"869\" height=\"165\" title=\"\">\n<p>As we can see, example 2 is now clean, as seen in cell C3, and the length of the clean string is 34 after removing the extra space and a non-printable character. However, in example 1, the non-printable character is removed, but there is still an extra space in the beginning.<\/p>\n<p>This hidden space character is called a non-breaking space (nbsp) usually appears in Excel when we download data from another program or copy-paste from any webpage on the internet. The non-breaking space character is represented by CHAR(160).<\/p>\n<p>To remove it, we need to combine the SUBSTITUTE function with the TRIM and CLEAN functions.<\/p>\n<p>The SUBSTITUTE function will replace CHAR(160) with a space. The CLEAN and TRIM function can then remove the extra space and non-printable characters. The final function will be as follows.<\/p>\n<div class=\"excelFormula\"><code><span class=\"operator\">=<\/span><span class=\"function\">TRIM<\/span>(<span class=\"function\">CLEAN<\/span>(<span class=\"function\">SUBSTITUTE<\/span>(B2,<span class=\"function\">CHAR<\/span>(160),\" \")))<\/code><\/div>\n<img decoding=\"async\" class=\"aligncenter size-full wp-image-7381\" src=\"https:\/\/exceltrick.com\/wp-content\/uploads\/2022\/10\/clean-function-in-excel_16.png\" alt=\"Removing Unicode Non-printing Characters\" width=\"872\" height=\"164\" title=\"\">\n<p>We can now clean up all the data even if it contains a hidden space. As Unicode is a vast character set, there are several other non-printable characters, such as 129, 141, 143, 144, and 157, which might create interference in the data. We can easily remove them using the same method.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"CLEAN_vs_TRIM_Function\"><\/span>CLEAN vs. TRIM Function<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>As we have seen in the above examples, the TRIM function cleans up extra spaces while the CLEAN function removes non-printable characters belonging to ASCII code. The space corresponds to CHAR(32), while the CLEAN function strips the first 32 characters (0-31).<\/p>\n<p>That wraps up our discussion on the CLEAN function. While you solidify your expertise with some practice, we&#39;ll go put together another tutorial with some nifty formulas to help you become an undefeated Excel champion.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The CLEAN function comes under the category of text\/string functions in Excel. It is used to remove first 32 non-printable characters from the text. Based on the 7-bit ASCII character set, codes starting from 0 to 31 are considered as Non-Printing Control Characters such as horizontal tab, vertical tab, carriage return etc. The CLEAN function [&hellip;]<\/p>\n","protected":false},"author":9,"featured_media":7382,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"_links":{"self":[{"href":"https:\/\/exceltrick.com\/wp-json\/wp\/v2\/posts\/7361"}],"collection":[{"href":"https:\/\/exceltrick.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/exceltrick.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/exceltrick.com\/wp-json\/wp\/v2\/users\/9"}],"replies":[{"embeddable":true,"href":"https:\/\/exceltrick.com\/wp-json\/wp\/v2\/comments?post=7361"}],"version-history":[{"count":0,"href":"https:\/\/exceltrick.com\/wp-json\/wp\/v2\/posts\/7361\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/exceltrick.com\/wp-json\/wp\/v2\/media\/7382"}],"wp:attachment":[{"href":"https:\/\/exceltrick.com\/wp-json\/wp\/v2\/media?parent=7361"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/exceltrick.com\/wp-json\/wp\/v2\/categories?post=7361"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/exceltrick.com\/wp-json\/wp\/v2\/tags?post=7361"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}