Split the names into two parts again by using the below formulas (where E2 is a comma-separated name): Get thefirst name: =RIGHT(E2, LEN(E2) - SEARCH(" ", E2)) Get thelast name: =LEFT(E2, SEARCH(" ", E2) - 2) And bring the two parts together: =G2&" "&H2 Perform the ...
If you want to sort your sheets indescending alphanumeric order(Z to A, then sheets with numeric names), then use the following code: SubTabsDescending()Fori = 1ToApplication.Sheets.CountForj = 1ToApplication.Sheets.Count - 1IfUCase$(Application.Sheets(j).Name) < UCase$(Application.Sheets...