Let's say I have cells that each contain a number string, and the cells themselves are formatted as text:
323435344435055
055443543534323
435340553234435
I want to sort within each cell so the output data for all looks like (must be text format because of the potential 0's at the beginning of the string):
023333344445555 - output sample
Number of characters per cell could differ. Solution REQUIRED with VBA UDF
As always, thanks in advance.
323435344435055
055443543534323
435340553234435
I want to sort within each cell so the output data for all looks like (must be text format because of the potential 0's at the beginning of the string):
023333344445555 - output sample
Number of characters per cell could differ. Solution REQUIRED with VBA UDF
As always, thanks in advance.