I want number 221. Or 361 to be 22L and 36L
Are you looking for this formula?
=MID(A1;1;LEN(A1)-1)&SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(RIGHT(A1;1);"0";"");"1";"L");"2";"R")
1 Like
THANK YOU THANK YOU THANK YOU !!!
I got almost 5000 ILS runway freq exported with a Pete Dowson (FSUIPC) util
but i noticed the format of the runway number needed a little work
worked P E R F E C T L Y as you provided
thanks again !
Bob Higgins
And 311 to be 31L
All using 1 formula
FYI— here is my data for FSX flight Sim ILS runways:
350 needs to show 35
30 needs to show 3
271 needs to show 27L
171 needs to show 17L
272 needs to show 27R
110 needs to show 11
any help greatly appreciated
I found close formulas but not one that will do it