Find and replace won't replace a parenthesis by nothing without changing the cell format

Question

Hello everyone,I'm using the "find and replace" feature in excel 365 and I'd like to replace a parenthesis by nothing, in order to get rid of it. But everytime I try to do that, the cell format change to date and time and modifies the content of said cell, even if I select the text format before hand.&nbsp;If I try do select text format like so :&nbsp;&nbsp;It act like it's all good and done but nothing changes ...So my question is : WHY ? does such thing happen ?Cheers&nbsp;

riny_van_eekelen · Answer

Arzock&nbsp;The semicolon make Excel think you are entering a time. Try this:=LEFT(&lt;cell&gt;,LEN(&lt;cell&gt;)-1).... and then copy /paste values.&nbsp;

Forum Discussion

Find and replace won't replace a parenthesis by nothing without changing the cell format

1 Reply

Resources