Hello,
I want to manipulate strings of text/numbers. See attached my spreadsheet.
If part of the string has one number in parentheses e.g. A(1), that can be left as it is. For parts with more than one number e.g. F(1,100,200), I want this broken down into F(1),F(100),F(200).
The "Original" is my string currently and "New" is what I want it to finish as.
I have hundreds of such strings so it cannot be done manually. Any suggestions/assistance will be appreciated.
Thanks.
Bookmarks