Move first 5 character to the right

[gabada]

Hello guys,

Need your help with excel. Couldn't find out how to do next function, I want to move 5 characters from left side to the right side. Here is an example what I want to get.

I have searched for some formulas like " =RIGHT(A2,LEN(A2)-FIND(" ",A2))&" "&LEFT(A2,FIND(" ",A2)-1) " But cannot get result.

 

ADJR_Achkva   from this I want to get > Achkhva_ADJR

ADJR_Keda_HOC   from this I want to get > Keda_HOC_ADJR

ADJR_Khelvachauri_TV   from this I want to get >   Khelvachauri_TV_ADJR

BATM_Batumi_Circus    from this I want to get >   Batumi_Circus_BATM

IMRT_Chiatura_TV     from this I want to get >   Chiatura_TV_IMRT

 

I want this solution cause I have 1000+ results like this.

Thank you in advance.

 

[boggy77]

use the split cells function based on the "_" symbol and then concatenate them back together in your preferred order

[gabada]

35 minutes ago, boggy77 said:

use the split cells function based on the "_" symbol and then concatenate them back together in your preferred order

Thanks for your response. But I did it different way.
I have used =LEFT(A1,5)  to get 5 characters from left side (  ADJR_ )  than did Reverse Text Order by "_"  and got ( _ADJR ).

After I had to took Achkhva from ( ADJR_Achkhva ) , I have split cell from first 5 character and got Ackhva , after I have merged cells Achkva_ADJR and got my result   Thank you