SOLVED

switching text in a string

%3CLINGO-SUB%20id%3D%22lingo-sub-3216982%22%20slang%3D%22en-US%22%3Eswitching%20text%20in%20a%20string%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3216982%22%20slang%3D%22en-US%22%3E%3CP%3EI%20tried%20to%20figure%20out%20how%20to%20switch%20a%20text%20where%20I%20want%20to%20move%20the%20last%20characters%2C%20always%20the%20same%2C%20to%20the%20beginning%20instead%3C%2FP%3E%3CP%3EFor%20example%3C%2FP%3E%3CP%3Ecar.flx%3C%2FP%3E%3CP%3Ebike.flx%3C%2FP%3E%3CP%3E...%3C%2FP%3E%3CP%3Eshould%20become%3C%2FP%3E%3CP%3Eflx.car%3C%2FP%3E%3CP%3Eflx.bike%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eand%20so%20on%3C%2FP%3E%3CP%3Ethanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3216982%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3217006%22%20slang%3D%22en-US%22%3ERe%3A%20switching%20text%20in%20a%20string%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3217006%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F253261%22%20target%3D%22_blank%22%3E%40stepic7%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAs%20variant%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-excel-formula%22%3E%3CCODE%3E%3DRIGHT(A1%2C%20LEN(A1)%20-%20FIND(%22.%22%2CA1)%20)%20%26amp%3B%20%22.%22%20%26amp%3B%20LEFT(%20A1%2C%20FIND(%22.%22%2CA1)%20-%201)%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3217009%22%20slang%3D%22en-US%22%3ERe%3A%20switching%20text%20in%20a%20string%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3217009%22%20slang%3D%22en-US%22%3EUse%20Flash%20Fill.%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3217065%22%20slang%3D%22en-US%22%3ERe%3A%20switching%20text%20in%20a%20string%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3217065%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethanks%20a%20lot%3C%2FP%3E%3CP%3Econgratulations%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3217066%22%20slang%3D%22en-US%22%3ERe%3A%20switching%20text%20in%20a%20string%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3217066%22%20slang%3D%22en-US%22%3Esorry%20don't%20know%20what%20you%20mean%20by%20flash%20fill%3C%2FLINGO-BODY%3E
New Contributor

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

6 Replies
best response confirmed by stepic7 (New Contributor)
Solution

@stepic7 

As variant

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

 

Use Flash Fill.

@Sergei Baklan 

thanks a lot

congratulations

sorry don't know what you mean by flash fill

@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

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