Hello again everybody,

in cells A1:A45 I want to paste a text that comes from an email. I've formatted the column as text. This is how the text that I want to paste looks like:



-ML/N

but when I paste it this is what I get

'-ML/N

I am using the following formula to extract a specific text from a line (thank you again Catalin):

=IFERROR(LEFT(SUBSTITUTE(A1;LEFT(A1;FIND("/";A1));"");FIND("/";SUBSTITUTE(A1;LEFT(A1;FIND("/";A1));""))-1);"")

At this point the cells that should be blank contain the apostophe.

Is there a way to eliminate this?

Thank you all