switching text in a string

[stepic7]

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

and so on

thanks

[#2 · Accepted solution]

@stepic7 

As variant

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

[#3]

Use Flash Fill.

[#4]

@Sergei Baklan 

thanks a lot

congratulations

[#5]

sorry don't know what you mean by flash fill

[#6]

@stepic7 

Well, I mean Flash Fill because it is called Flash Fill.

https://www.google.com/search?q=what+is+flash+fill+in+excel&oq=what+is+flash+fill

[#7]

@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.