I am wondering if its possible to have a VBA to convert a cell with multipule lines? I have a file that has 500+ cell that have multi-lines, so i am looking to have a costume vba where i can = to a cell. I have put an example what I want
<tbody>
</tbody>
We can see that in B1 the number is not sorted. I am wondering if there is a VBA formula to make it in order as the next example
<tbody>
</tbody>
Cell one | 1 6 8 7 11 23 456 4 12 13 465 251 631 |
<tbody>
</tbody>
We can see that in B1 the number is not sorted. I am wondering if there is a VBA formula to make it in order as the next example
Cell one | 1 4 6 7 8 11 12 13 23 251 456 465 631 |
<tbody>
</tbody>