Excel Example 1

Here I am presenting my Excel Example 1. Its shows how to separate Scheme Name and Scheme Code if they are in combination. 

Divide Texts

Divide Texts

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 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.

We will be happy to hear your thoughts

      Leave a reply

      This site uses Akismet to reduce spam. Learn how your comment data is processed.

      DEO West Bengal