
Here I am presenting my Excel Example 1. Its shows how to separate Scheme Name and Scheme Code if they are in combination.
Excel function used in Step 1 :
=IFERROR(RIGHT(F2, LEN(F2)- SEARCH("(",F2) - LEN("(") + 1),"")
Excel Function used in Step 2 :
=IFERROR(LEFT(G2,SEARCH(")",G2)-1),"")
Subhrapratim De
Subhrapratim De is a Data Entry Operator (DEO/VLE) under MGNREGA Scheme. He is working at the ground level (Gram Panchayat) since 2008 in West Bengal. He has strong background knowledge of computer system, network and operating system. He has knowledge of programming and databases too. Lastly he is a part time blogger.