I have an excel spreadsheet with a single column, consisting of "Lastname, Firstname (group)" format. (ie: Guy, Tech (Support) )
How can I change the format in these text fields to first, remove the "(Support)" part, and then reverse the firstname/lastname, so all I have in the column (or...