Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Search for a word in string
#6
Not Solved
Try this,

Code:
For i=1 to ColumnCount
    For j=1 to RowCount
        c= objSheet.Cells(j,i).Value
        k= InStr(c,")")
        if k>0
            objSheet.Cells(j,i).Value= Mid(c,k+1)
        end if
    Next
Next
Reply


Messages In This Thread
Search for a word in string - by QAVA - 11-21-2012, 03:05 AM
RE: Search for a word in string - by hiregoudar - 11-21-2012, 02:49 PM
RE: Search for a word in string - by maroli - 11-21-2012, 04:03 PM
RE: Search for a word in string - by QAVA - 11-21-2012, 09:56 PM
RE: Search for a word in string - by ssvali - 11-22-2012, 03:56 PM
RE: Search for a word in string - by Saleel Prabhu - 11-22-2012, 04:50 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  CyberArk CorePAS REST API to search for accounts pramod 0 564 06-29-2023, 03:11 PM
Last Post: pramod
  UFT Word automation wannel 1 2,160 10-31-2016, 06:59 PM
Last Post: wannel
  Search All Test scripts For a Function? AndyBSG 1 2,582 02-19-2015, 04:15 AM
Last Post: supputuri
  Replace a string in a word document with another string rekha.naik 8 15,067 11-14-2013, 12:58 PM
Last Post: pranikgarg
  Search for a string in all the files under all subdirectory Mahesh27 1 2,050 07-03-2013, 03:24 PM
Last Post: Sathiya

Forum Jump:


Users browsing this thread: 1 Guest(s)