Forum Discussion
Removing double quotes around strings returned by formulae
I've constructed a cell range using concatenate which works fine except that when it is returned, Excel sticks double quotes around them and my match function fails. I've tried trim&substitute. I've...
Not sure about this, but it looks to me as if what might want is =INDIRECT("D35:D42")
Try that. If it's not what you're seeking, come back with an example spreadsheet and a more complete description.
- thanks Mathetes. Looks like that's worked. you're a life saver 🙂
hi , i have the same problem, i couldn't solve it with indirect !!
any suggestions plz ?
It's probably not the same problem then, wouldn't you think? So let's start with a more complete description of whatever the problem is that you're experiencing. And, if it's possible--if your spreadsheet doesn't contain confidential or proprietary info--please post a copy of the spreadsheet itself in OneDrive or GoogleDrive and paste a link here that grants edit access.
