I would also like to extract the number. The one between "n." and the date in order to sort them by date, and if the date is the same, progressively by number. If it were possible to do everything in one formula it would be better, to have one columnyou are welcome
well, i'm not a mod, and its a different question , as i say i have seen these closed in the past midway through
but only way i know would be to extract the number as text and convert to a number - using *1 as partof the formula and then using that column
in a new column
then you can sort by date and then by the number -
maybe a way to do without the new column, not sure - but it will also depend on your version of excel - what is it ?
even with TEXTbefore() and textafter()