MS-EXCEL | How to use Right | Left | Mid In Advance Method ?
Follow me on Instagram 📲~~~
https://www.instagram.com/analytics_j...
Use the below Syntex
.
.
.
.
.
Syntex for Right
=RIGHT(A1,LEN(A1)-FIND("_",A1,FIND("_",A1)-1)
Syntex for Left
=LEFT(A1,FIND("_",A1)-1)
Syntex for Mid
=MID(A1,FIND("_",A1)+1,FIND("_",A1,FIND("_",A1)+1)-FIND("_",A1)-1)