I want to remove a backspace (enter key) after some numbers. Trim doesn't recognise the backspace as a space. I have also tried find and replace but that doesn't recognise the backspace as a space either. I have also tried multiplying all the numbers by 1 in another column to get a purely numerical response but that doesn't work either. The cells are formatted as numbers.
You could Control-H to open up the find and replace. Then, in the "Find What" field, enter a Control-J. It'll look like a dot, but it's a line return.
If you just want it gone, leave "Replace With" blank and hit Replace All.