adding mark comma (') after last string

[muhammad susanto]

hi all,

how to adding mark comma (') after last text but before 2 string last..

[TABLE="width: 500"]
<tbody>[TR]
[TD]THE BEST ONE UNITIMBER PT[/TD]
[TD]THE BEST ONE UNITIMBER,PT[/TD]
[/TR]
[TR]
[TD]SANI UTAMA CV[/TD]
[TD]SANI UTAMA,CV[/TD]
[/TR]
[TR]
[TD]..[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

red mark just clue
note : not vba
somebody could help me, thanks in advance...

 

[muhammad susanto]

acrross post http://www.mrexcel.com/forum/excel-questions/814647-moving-2-character-first-last.html

 

[azumi]

Maybe:

=REPLACE(REPLACE(A1;LEN(A1)-LEN(TRIM(RIGHT(SUBSTITUTE(A1;" ";REPT(" ";99));99)));0;",");LEN(A1)-LEN(TRIM(LEFT(RIGHT(SUBSTITUTE(" "&TRIM(A1);" ";REPT(" ";20));80);80)));0;",")

 

[Peter_SSs]

acrross post http://www.mrexcel.com/forum/excel-questions/814647-moving-2-character-first-last.html

This is a duplicate post rather than a cross-post.

Questions of a duplicate nature will be locked or deleted, per #9 of the Forum Rules.

Any bumps, clarifications, or follow-ups should be posted to the linked thread.