Forum Discussion

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

and so on

thanks

Formulas and Functions

As variant

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

6 Replies

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.
Detlef_Lewin
Silver Contributor
Feb 26, 2022
Use Flash Fill.
- stepic7
  Copper Contributor
  Feb 26, 2022
  sorry don't know what you mean by flash fill
  - Detlef_Lewin
    Silver Contributor
    Feb 26, 2022
    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
SergeiBaklan
Diamond Contributor
Feb 26, 2022
stepic7

As variant

=RIGHT(A1, LEN(A1) - FIND(".",A1) ) & "." & LEFT( A1, FIND(".",A1) - 1)
- stepic7
  Copper Contributor
  Feb 26, 2022
  SergeiBaklan
  thanks a lot
  congratulations