Forum Discussion
Find and replace won't replace a parenthesis by nothing without changing the cell format
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 c...
The semicolon make Excel think you are entering a time. Try this:
=LEFT(<cell>,LEN(<cell>)-1).... and then copy /paste values.