Hi
I have an excel file that have data in it and I want to do text to column whereby the result (as screenshot) would add a new column (“Team ID”) with the team ID and removing the brakcets “(” and “)”.
Additional question: If the original column is not in Column A? Can this work if the column that I want to do text to column is in Column D.