I am getting one weird issue while searching a string value in Excel file using Lookup Range.
I have a string variable "Hello "&World I want to find this value and get the range of the cell in excel file.
I am searching with “Hello " + “””" + “&”+"World"
But I am getting the backslash symbol ** in my string variable and the robot is getting stuck.
I am unable to find why the " \" is appearing in the variable. When I tested the value with Log message activity, it is appearing correctly but in LookUp Range Value, the backslash is adding ** and the robot is unable to search the value.
Please find the below screenshot for the same.