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)

     

Detlef_Lewin's avatar
Detlef_Lewin
Silver Contributor
Feb 26, 2022
Use Flash Fill.
stepic7's avatar
stepic7
Copper Contributor
Feb 26, 2022
sorry don't know what you mean by flash fill