Make Single Formula (Joint 2 Formula in 1 Formula)

[muhammad susanto]

hi all,

how to joint & make simple in single formula like this :

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]sample raw[/TD]
[TD]after formula (single code)[/TD]
[/TR]
[TR]
[TD]CV ASRI INTI KARYA[/TD]
[TD]ASRI INTI KARYA, CV [/TD]
[/TR]
[TR]
[TD]PT ANDALAS LOGAMINDO[/TD]
[TD]ANDALAS LOGAMINDO, PT [/TD]
[/TR]
</tbody>[/TABLE]

maybe here code

[COLOR=#333333]=MID(A1,4,255)&" "&LEFT(A1,2)[/COLOR]

=REPLACE(A1,LEN(A1)-2,1,",")

note : red font just clue

how to make single formula?

any assistance, thanks in advance...

m.susanto

 

[mfexcel]

assume it always starts with 2 letters and a space...

Try:
=SUBSTITUTE(A1,LEFT(A1,3),"")&", "&LEFT(A1,2)

 

[muhammad susanto]

hello mfexcel...

it's wonderful...
thank you very much [solved]

 

[mfexcel]

You are welcome. Thanks for feedback.