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)

     

OliverScheurich's avatar
OliverScheurich
Gold Contributor
Feb 26, 2022

stepic7 

=LET(a,FIND(".",A1),
b,RIGHT(A1,LEN(A1)-a),
c,LEFT(A1,a-1),
CONCATENATE(b&"."&c))

An alternative could be above formula if you work with Office365 or 2021.