6 Replies Latest reply: Jun 10, 2015 8:01 AM by Mike Preuss RSS

    Column Problem

      If there is a column with location. all locations starts with "  SL. " now i want to remove this SL. but the thing is some of them dont have this so the right and mid comand is actualy cutting the first 3 letter so anything we can do for only selcting SL. and deleting the SL. only from SL.Mumbai and etc.

      Location name

      SL.Mumbai

      SL.Gurgaon

      Latur                 Here Lat is cutted if right or mid is used

      SL.Chennai