UFT importing incorrect data from Excel - Showing  in Vlookup
I'm importing some data from excel to UFT Datasheet. There are some Vlookups in my data and they work fine in excel, however post importing it UFT is adding "" as a prefix to the array of the function showing below.
Now, as you can see it has added  before Customer which is failing the function.
I have not encountered this myself so unfortunately I'm not able to provide you an actual fix for this. Might be something to do with Excel formatting as I believe that UFT datatables are not completely compatible with everything in the .xlsx file formats.
Anyway, as a workaround you should be able to use Replace() function after importing the data.
DataTable.Value("fieldName", "sheetName") = Replace(DataTable.Value("fieldName", "sheetName"), "", "")
In many cases though it might be best idea (personal opinion) not to have too much functions in the datatable but rather make the calculations in script where possible.