Hi all,
I have inputs in cells surrounded by quotation marks. I would like to remove quotation marks having pure text only. I tried using SUBSTITUTE formula, however met a problem how to declare that I want to remove quotation marks? Is there any way to remove quotation marks using SUBSTITUTE? If not, is there any alternative excel formulas to do it?
Important: please, don't mention VBA as I want to do it exclusively using excel formulas.
Thanks
I have inputs in cells surrounded by quotation marks. I would like to remove quotation marks having pure text only. I tried using SUBSTITUTE formula, however met a problem how to declare that I want to remove quotation marks? Is there any way to remove quotation marks using SUBSTITUTE? If not, is there any alternative excel formulas to do it?
Important: please, don't mention VBA as I want to do it exclusively using excel formulas.
Thanks