Moving 2 character from first to last

[muhammad susanto]

hi guys..

here my problem, i hope you could help me..

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]sample raw[/TD]
[TD]after formula[/TD]
[/TR]
[TR]
[TD]CV CIPTA TERESAN JAYA[/TD]
[TD]CIPTA TERESAN JAYA CV[/TD]
[/TR]
[TR]
[TD]CV SINAR SUKSES ABADI PEKANBARU[/TD]
[TD]SINAR SUKSES ABADI PEKANBARU CV[/TD]
[/TR]
[TR]
[TD]PT NUANSA PERTIWI[/TD]
[TD]NUANSA PERTIWI PT[/TD]
[/TR]
[TR]
[TD]...[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

note : red font just a clue..2 characters moved
without vba

thanks all..

 

[Fazza]

selamat siang, Bpk

=MID(A1,4,255)&" "&LEFT(A1,2)

Selamat. Fazza

 

[muhammad susanto]

hello Fazza. you are a hero....

many thanks!! great......

 

[Fazza]

You're very welcome

 

[muhammad susanto]

hi Fazza,...

could you help me about this problem, adding mark comma (') after last text before 2 last string...

CIPTA TERESAN JAYA CV-------CIPTA TERESAN JAYA,CV (expected result)
NUANSA PERTIWI PT-----------NUANSA PERTIWI,PT

 

[Fazza]

Sure, Bpk

Some comment about the first question. I assumed in the initial question, your first post, that the text had no extra spaces. If there are, maybe just add a TRIM function. So instead of

=MID(A1,4,255)&" "&LEFT(A1,2)
=MID(TRIM(A1),4,255)&" "&LEFT(TRIM(A1),2)

Assuming again that there are no extra spaces, how about this?
=LEFT(A1,LEN(A1)-3)&","&RIGHT(A1,2)

cheers

 

[muhammad susanto]

hi Fazza, you are really Superexcel...

matur nuwun....

 

[Peter_SSs]

You already have good working solutions for both problems, but for interest here is a slightly different approach to each.

Original question:
=MID(A1&" "&A1,4,LEN(A1))

Follow-up:
=REPLACE(A1,LEN(A1)-2,1,",")