There is unseen quotation marks in my cells that I want to remove. The text is BS_20C37_Wedgewood but whenever I copy and paste it to other platform it shows like this "BS_20C37_Wedgewood "
It adds " in front of the text and (space)" at the end.
Please do help me. Thanks!
To post as a guest, your comment is unpublished.· 1 years agoYou can enter =CLEAN(Cell#) in a blank cell then copy the result and paste special value only into the original cell
To post as a guest, your comment is unpublished.· 1 years agoDear benben,
Normally the quotation marks don't hide automaically in cells. Would you send me your workbook via email@example.com?
Thank you for your comment.