How To search for a particular word in an excel

I want to search a particular word in excel and if found then i need to take the 1st five character of that word and search it into the another excel sheet. And another remaining character also need to search in another excel sheet.

Please helpp!!

hi @Tabbu

  • You can try with lookup datatable and get the cell value
  • Use regex or split or Substring get the 1st and last 5 five characters
  • Use 2 Lookupdatable and search for those in different excel

or

  • Loop through the all the rows and give if condition to match the specific word
  • Use regex or split or Substring get the 1st and last 5 five characters and break activity
  • Use those values and loop through the two different data table and find the value

Hope this Helps

Regards
Sudharsan