Forum Discussion
How to sort numbers with a space in the one cell
Hi - Have been searching online but can't find the correct formula. Is there a way to sort numbers in order i.e. lowest to highest within one excel cell as per below when there is a space between val...
EVALUATE() is available in any version of Excel starting from Excel 4.0.
That I know ,,, my expectation is that the answerer must show the correct way to create & implementation of UDFs ,, Macro & features like LAMBDA,,, how may users are familiar with new arrivals !!
Sorry, I didn't catch. Code for both UDF (cell.value and eval) is presented. The rest are native functions like SORT(), LAMBDA(), SUBSTITUTE(), LET()