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 :

data	expected result
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>
</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).