Tricky SUBSTITUTE or REPLACE

What's the best way to swap the digits inside each cell of the L column?
That is, the first digit should be replaced by the second, and the second digit should be replaced by the first.
2-0 will be 0-2
2-1 will be 1-2
3-0 will be 0-3
3-1 will be 1-3
3-2 will be 2-3

EDIT: it think it can be done with IF

IF(L1="2-0","0-2", and then nested ifs for each case.. so I think I got it solved

Also on a sidenote, is there any easy way to automatically select the last 30/60 days from the date pickers? They are linked to cells T15 and T28 but if I change the dates in the cells manually I get an error, possibly because of the DATEVALUE in the date selection formula.

Thanks!

Hi,

Perhaps, if both values are single digits:

=TEXT(SUMPRODUCT(0+MID(L2,{3,1},1),10^{1,0}),"0-0")

Regards

Or =RIGHT(L2) & "-" & LEFT(L2)

@shg

I know. Just trying something different!

And a fine formula it is! It lacks only some trig functions for perfection. +Rep if you work one in.

Does this count?

=TEXT(SUMPRODUCT(DEGREES(RADIANS(0+MID(L2,{3,1},1))),10^{1,0}),"0-0")