this is an Excel issue. DO NOT USE: textsplit , textbefore, and textafter .

I have a table that looks like like table-1

below. I want it to turn into

table-2. Please dont give me any formula

where I have to use specifc names. my actual table is far too large and has too many diffrernt names for me to use a formula like that. all units in the column in my actual table have commas as well.

Table-1 \begin{tabular}{|l|} \hline NAME \\ \hline Biden, Joe \\ \hline Trump, Donald \\ \hline Obama, Barack \\ \hline Bush, George \\ \hline \end{tabular} Table-2 \begin{tabular}{|l|} \hline NAME \\ \hline JOE BIDEN \\ \hline DONALD TRUMP \\ \hline BARACK OBAMA \\ \hline GEORGE BUSH \\ \hline \end{tabular}