How to remove quotes in an Excel column?

Question

excel

You need to remove the quotes in the product names in the column so that instead of "Toshiba TV" it becomes Toshiba TV.

Answer 1

CTRL+H
Change quotes to "blank".
If you need a formula, then this formula removes one character at the beginning and from the end of the string.
=ЛЕВСИМВ(ПРАВСИМВ(A1;ДЛСТР(A1)-1);ДЛСТР(A1)-2)

Answer 2

Find or replace text and numbers in a worksheet
https://support.office.com/en-us/article/Search-or...