Feb 26 2022 10:35 AM
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
Feb 26 2022 10:40 AM
SolutionFeb 26 2022 12:14 PM
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
Feb 26 2022 12:21 PM
=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.
Feb 26 2022 10:40 AM
SolutionAs variant
=RIGHT(A1, LEN(A1) - FIND(".",A1) ) & "." & LEFT( A1, FIND(".",A1) - 1)