NewOrderFac33
Well-known Member
- Joined
- Sep 26, 2011
- Messages
- 1,275
- Office Version
- 2016
- 2010
- Platform
- Windows
Good afternoon - I have a number of cells containing multiple version strings similar to: "1.10, 1.11, 1.12, 1.14, 1.16.1, 1.8.1, 1.9" (some of them might only contain one e.g. 1.10 with no trailing comma)
I need to be able to replace the contents of the cell with the first value (in this case 1.10) then extract each of the subsequent values (not including any spaces or commas) and write them to the cells immediately below.
So, if this was Cell A1, A1 would end up containing 1.10, A2 would contain 1.11, A3 would contain 1.12 and so on.
Can anyone help me out, please?
Thanks
I need to be able to replace the contents of the cell with the first value (in this case 1.10) then extract each of the subsequent values (not including any spaces or commas) and write them to the cells immediately below.
So, if this was Cell A1, A1 would end up containing 1.10, A2 would contain 1.11, A3 would contain 1.12 and so on.
Can anyone help me out, please?
Thanks