I need help implementing changes to and sdf downloaded file that has a specific format that needs to be followed. I need to be able to transpose and implement parentheses and semicolons along with changing the 9 digit number within the parentheses. For example I would like to change this
((492980625;);); ((504863335;);); into this ((898980625;);); ((604863345;););
Also if I have the above numbers running down a column, I would like to implement the parentheses & semicolon format into a single cell.
Hopefully I explained this problem well enough, I believe if I was able to share my screen it would be more understandable.
Solved by T. H. in 30 mins