decadence
Well-known Member
- Joined
- Oct 9, 2015
- Messages
- 525
- Office Version
- 365
- 2016
- 2013
- 2010
- 2007
- Platform
- Windows
Is it Possible to sort a cell with comma delimited alphanumeric text, I know it can be done using a helper column but I was wondering if it can be done by string/arrays,
Ideally I would like to pass the cell value to an array/string and sort that alphanumerically then pass the sorted text back to the same cell, Can someone help please
Example
From this
To this
Ideally I would like to pass the cell value to an array/string and sort that alphanumerically then pass the sorted text back to the same cell, Can someone help please
Example
From this
D11, D12, D13, D14, D2, D3, D4, D9 D10 |
To this
D2, D3, D4, D9, D10, D11, D12, D13, D14 |