How to remove hidden quotes in excel

Method 1:

Use the right and len functions and the value function.

The left function is a formula that intercepts a specified number of characters from the right, len is to find the length of the cell, and value is to convert the text into a number;

Confirm how many there are through Ctrl F For cells, in the example to confirm that there is only one space, use right to get the value: RIGHT(B3,LEN(B3)-1). The value that comes out is text and needs to be converted to a number, so use VALUE: VALUE(RIGHT( B3,LEN(B3)-1))

Method 2:

Use the value function and clean function.

The clean function is to delete all non-printing characters in the text, such as spaces, quotation marks and other characters that are invisible when printed.

Formula: CLEAN(B3), then converted into a number: VALUE(CLEAN(B3))

For more related questions, you can check: exceltutorial

The above is the detailed content of How to remove hidden quotes in excel. For more information, please follow other related articles on the PHP Chinese website!