Forum Discussion

stepic7's avatar
stepic7
Copper Contributor
Feb 26, 2022
Solved

switching text in a string

I tried to figure out how to switch a text where I want to move the last characters, always the same, to the beginning instead For example car.flx bike.flx ... should become flx.car flx.bike ...
excel
Formulas and Functions
  • SergeiBaklan's avatar
    SergeiBaklan
    Feb 26, 2022

    stepic7 

    As variant

    =RIGHT(A1, LEN(A1) - FIND(".",A1) ) & "." & LEFT( A1, FIND(".",A1) - 1)

     

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Feb 26, 2022

stepic7 

As variant

=RIGHT(A1, LEN(A1) - FIND(".",A1) ) & "." & LEFT( A1, FIND(".",A1) - 1)

 

  • stepic7's avatar
    stepic7
    Copper Contributor
    Feb 26, 2022

    SergeiBaklan 

    thanks a lot

    congratulations