Forum Discussion
stepic7
Feb 26, 2022Copper Contributor
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
and so on
thanks
6 Replies
- OliverScheurichGold Contributor
=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.
- Detlef_LewinSilver ContributorUse Flash Fill.
- stepic7Copper Contributorsorry don't know what you mean by flash fill
- Detlef_LewinSilver Contributor
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
- SergeiBaklanDiamond Contributor
- stepic7Copper Contributor