NEED help with a function on excel for Q1

and Convert the Date question(4)

Raw dates are in the picture must use text functions

- Insert a new column - Provider Type - that will display "Medical Facility" if the word "hospital" is part fo the provider name, "Dentar" for any provider with "dds" in the name. All other rows should be left blank. - Display the provider address without the "ADDRESS1:" prefix in the column. Convert the data to proper case. - Split the City and State data into separate columns. - Display only the standard 5-digit zip code. - Convert the Date Added column to display in the format of mm/dd/yyyy. (Be sure to take note of the different variations of this data in your formula. You may need to solve this one in multiple steps.) \begin{tabular}{|l|l|} \hline Date \\ \hline FACIUTY & 11292017 \\ \hline & 5232018 \\ \hline 1262011 \\ \hline 8182020 \\ \hline 10282017 \\ \hline 1292015 \\ \hline 7292021 \\ \hline 1152010 \\ \hline 832019 \\ 10192021 \\ 6292020 \\ 10152017 \\ 632015 \\ 1182022 \\ \hline 12272014 \\ 5212013 \\ \hline 7252012 \\ \hline 4222012 \\ \hline 972012 \\ \hline 982018 \\ \hline 12202018 \\ 342017 \\ 732015 \\ 482020 \\ \hline \end{tabular}