• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer
DEOWB_LOGO_192X192

DEO West Bengal

The DEO Education Channel

  • Home
  • New Updates
  • Tutorials
  • ORDER
  • PAYMENTS
  • ISGP
  • UTILITY
  • Videos
You are here: Home / TUTORIAL / Excel Example 1

Excel Example 1

November 21, 2016 by Subhrapratim De

Divide Texts

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),"")

 

Filed Under: TUTORIAL, UTILITY

Reader Interactions

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

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

Primary Sidebar

Footer

About Us

DEOWB (Data Entry Operators - West Bengal) was started in 2009 as deowestbengal.wordpress.com to help all the DEO/VLEs working under MGNREGA schemes. With times things have changed to this. If you are a DEO/VLE, you are at the right place. This is the ultimate DEO Education Channel..!!!

Social

  • Facebook
  • YouTube

© 2009–2023 DEO West Bengal