Hi,
I'm working on a follow which gets an excel file from my one drive and filters through its data, I used the contains() function for starters and it worked perfectly, the issue is with the 'Sales person' column and others similar to it. I tried the substituting the whitespace with _x0020_ as some posts suggested but its now working for me.
I've tried enclosing the Sales person column in double quotes and single quotes, substituting with _x0020_ and also tried enclosing Sales_x0020_person in double and single quotes while I was at it, but none of it works, so please help me

Report
All responses (
Answers (