Mar 31 2020 07:10 AM
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.
If I try do select text format like so :
It act like it's all good and done but nothing changes ...
So my question is : WHY ? does such thing happen ?
Cheers
Mar 31 2020 08:05 AM
The semicolon make Excel think you are entering a time. Try this:
=LEFT(<cell>,LEN(<cell>)-1)
.... and then copy /paste values.