Image by Author I used only 3 prompts to convert an unstructured data column in Excel to a structured column. First prompt Give me a function that will extract only email addresses from a cell and make sure it removes all the other text and special characters Output: =TRIM(RIGHT(SUBSTITUTE(LEFT(A1, FIND(“ “, A1&” “, FIND(“@”, A1))-1), “ “, REPT(“ “, LEN(A1))), LEN(A1))) This function resulted in <emily.jones@example.com>, Second prompt The function you provided is working but it also extracted special characters <, >, and , that are associated with the email value but I do not want these special characters so now create a formula that remove only these characters from < emily.jones@example.com >, Output: =FILTERXML(“<t><b>” & SUBSTITUTE(B1, “<”, “”) & “</b></t>”, “//b”) This function gave me emily.jones@example.com>, Third prompt The function you provided remove only < from < emily.jones@example.com >,...