muhammad susanto
Well-known Member
- Joined
- Jan 8, 2013
- Messages
- 2,077
- Office Version
- 365
- 2021
- Platform
- Windows
hi all...
i have problem how to reverse order text with criteria like this :
Excel 2013 64 bit
<tbody>
</tbody>
<tbody>
</tbody>
i have use :
=MID(TRIM(A1);4;255)&", "&LEFT(TRIM(A1);2)
but not fully working for the lion king.....and michael jordan not work for both
how to make work well...
thanks/m.susanto
i have problem how to reverse order text with criteria like this :
Excel 2013 64 bit
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]F[/COLOR] | [COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]G[/COLOR] | |
---|---|---|
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]4[/COLOR] | PT THE BIS BOSS | THE BIS BOSS, PT |
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]5[/COLOR] | CV. MAKE YOU HAPPY | MAKE YOU HAPPY, CV |
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]6[/COLOR] | H. MICHAEL NOORMAN | MICHAEL NOORMAN, H |
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]7[/COLOR] | THE LION KING | THE LION KING |
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]8[/COLOR] | MICHAEL JORDAN FRANKY LARGE | MICHAEL JORDAN FRANKY LARGE |
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]9[/COLOR] | ETC.. |
<tbody>
</tbody>
Sheet: Sheet1 |
<tbody>
</tbody>
i have use :
=MID(TRIM(A1);4;255)&", "&LEFT(TRIM(A1);2)
but not fully working for the lion king.....and michael jordan not work for both
how to make work well...
thanks/m.susanto
Last edited: