Reverse Order After First Spacing

[muhammad susanto]

hi all..

how to reverse order this text below after first space and the final answer adding mark (,) comma
like this :

PT. Big Boss	Big Boss, PT
Drs Agung Maju Sejati	Agung Maju Sejati, Drs
CV. Indah Karya Solution	Indah Karya Solution, CV
FA Tiger Chong Great	Tiger Chong Great, FA

<tbody>
[TD="align: center"] data [/TD]
[TD="align: center"] expected result [/TD]

</tbody>

any help, much appreciated...

m.susanto

 

[jtakw]

Hi,

This is one way:

Book1
	A	B	C
1	data	expected result	jtakw Formula
2	PT. Big Boss	Big Boss, PT	Big Boss, PT
3	Drs Agung Maju Sejati	Agung Maju Sejati, Drs	Agung Maju Sejati, Drs
4	CV. Indah Karya Solution	Indah Karya Solution, CV	Indah Karya Solution, CV
5	FA Tiger Chong Great	Tiger Chong Great, FA	Tiger Chong Great, FA
Sheet143

Cell Formulas
Range	Formula
C2	=TRIM(SUBSTITUTE(MID(A2,FIND(" ",A2),255)&", "&LEFT(A2,FIND(" ",A2)),".",""))

C2 formula copied down.

 

[muhammad susanto]

hi jtakw....working well!!!
thank so much...
it possible if use macro/vba?

 

[jtakw]

You're welcome.

If you wanted a VBA solution Only, you should have specified that in your OP and/or the Thread title...
I'm afraid I can only provide you a formula solution.

I'm Sure someone will be able to provide you a VBA solution (I can already think of many).